3 Answers Found

You could use a Page Viewer Web Part to view specific SRS pages. You couldprobably also point a Data View Web Part at SQL and render stuff that way. I'venever done the latter, but I would imagine it would work.

There is also a report viewer web part. Or really, two web parts. One web part displays a list of reports to which the logged on user has access, and the other displays the report itself when selected from the list in the first web part.

The two web parts provided by Microsoft are called the Report Viewerand the Report Explorer. To me, it looks like they built the ReportViewer by extending a Page View web part to be connected link selectedin the Report Explorer (which in turn just lists the reports in afolder on the SQL Server 2005's Reporting Services web page).msdn2.microsoft.com/en-us/library/ms159772.aspx explains how toinstall them.

I found the default web parts pretty disappointing because it's veryhard to get a good view of the chart within the Report Viewer withouthaving to set the web part to a static (and very large) size.

I just found this article that tries to address the problem:http://aspalliance.com/729 . The code is in VB. Go figure. I dodgedthe problem by writing a web part that loaded up an image button witha tiny image of a report's chart into a panel, and then had the usersselect the report they wanted and drill through directly to theReporting Services pages by clicking on the image buttons.

If you have some money to spend, you could look at Decision SupportPanel (www.dspanel.com). If you have even more money to spend, theway to go seems to be ProClarity (www.proclarity.com). They have aproduct called ProClarity for SharePoint Portal Server, which appearsto be a free add on (once you buy ProClarity 6).

Go4Sharepoint, is a Microsoft Featured Community.
Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation.
All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.