Solved

Running reports through Sharepoint

Posted on 2011-03-17
3
342 Views
Last Modified: 2012-08-13
I have a SQL Server DATABASE with the wrong Collation (Latin) which I posted a previous message concerning not being able to load in Sharepoint.

I have now linked the database (table) to Microsoft Access and then linked again to a sharepoint list.    I am looking for some general advice on how i should go about running reports in sharepoint to querry this DB or list without sharepoint just loading Microsoft Access and giving a list of reports.

Any help appreciated.
Richard




0
Comment
Question by:RichardH1976
  • 2
3 Comments
 

Author Comment

by:RichardH1976
ID: 35161512
Actually after some more research tonight.   I think I would be happy to just run Access reports directly from Sharepoint.    I can run a view but cannot find anyway to run a report directly through sharepoint.

There is information online that implies I can do this but struggling to implement it.

Richard


0
 
LVL 42

Accepted Solution

by:
zephyr_hex (Megan) earned 500 total points
ID: 35325068
i would go with SSRS.  if it's the wrong collation, you may not be able to use sharepoint integration.  but you most certainly can still use SSRS and then display or link reports to sharepoint.
0
 

Author Closing Comment

by:RichardH1976
ID: 35358743
This was just a partial answer
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now