Sql Database to report upload to microsoft sharepoint

Pe-Killer

Expert Member
Joined
Aug 26, 2006
Messages
1,836
Reaction score
20
Hi,
Ok am looking for the best way of doing the following:
I need to create a report from selected information in a sql database and then share it over Microsoft Sharepoint with multiple users.

My idea is to use SQL Server Reporting Services to create the report save it as an excel sheet and then just upload it to Sharepoint workspace? Is this the best way? Can it even be done like this?

Any advice will be appreciated.
Thank you
 
Why not create the report and create a link on the SharePoint navigation pane to the report? :? This way the report is always up-to-date aswell.

If I'm understanding you correctly this should work..
 
Top
Sign up to the MyBroadband newsletter
X