Running reports through Sharepoint

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




RichardH1976Asked:
Who is Participating?
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
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
 
RichardH1976Author Commented:
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
 
RichardH1976Author Commented:
This was just a partial answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.