June 28, 2010 at 11:18 am
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:
July 15, 2010 at 6:07 am
I am guessing no one has any experience in doing this? Maybe I should look for a Sharepoint forum to post this to??? 😉
July 15, 2010 at 6:16 am
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
July 15, 2010 at 3:24 pm
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?
July 16, 2010 at 12:14 am
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
July 16, 2010 at 3:14 pm
Do have sample code in how to do this? Thanks!
July 20, 2010 at 11:05 am
Henrico: Help out don't leave me hanging on this.
July 21, 2010 at 5:31 am
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