Has anyone ever exposed SSMS standard reports in Sharepoint?
-
We all know if we right click on a object in SSMS and scroll down to Reports -> Standard Reports there is a list of reports we can possible choose from! My question is could we also view the same reports in a Sharepoint Webpart?
My background has been strictly SQL Server and have not done a thing until now in Sharepoint! :hehe: -
I am guessing no one has any experience in doing this? Maybe I should look for a Sharepoint forum to post this to???
-
Yes you can, and it works great!
Download Sharepoint Designer 2010 - it's free, and unleash the power
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
Well we are running SP 2007 with SQL Server 2005 backend! Currently there are no plans for SP 2010 yet, can I do this in SP 2007?
-
Yes, I've tested and no issues.
The designer is 2010, but the web part will work on SP 2007 as well.
Good Luck.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
Do have sample code in how to do this? Thanks!
-
Henrico: Help out don't leave me hanging on this.
-
Well here is what I have found so far:
1. The RDL files for the SSMS canned reports are availiable here:
2. Published them to SSRS.
3. Use the URL from SSRS in a Sharepoint Webpart.
Well now I have to test all this out thoroughly before I can use.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply