Raghu's SharePoint Corner: Integrating Reporting Services Native Mode in SharePoint

My blog has moved!

You will be automatically redirected to the new address. If that does not occur, visit
and update your bookmarks.

May 18, 2009

Integrating Reporting Services Native Mode in SharePoint

Today in this post i will be talkign about integation of Reporting Services with sharepoint in native mode. There are two possible ways to integrate Reporting Services in Sharepoint

1. Native Mode

When you configure Reporting Service to run in Native Mode, reports are displayed using an HTML Viewer interface that is built into Reporting Services. The HTML Viewer provides all of the basic functionality users required to view, navigate, and print reports. It also provides many Url parameter options to control report parameters and rendering rendering – options that are not available when viewing reports using the RSViewerPage page and the Report Viewer Web Part.

Yes, You Can Use the HTML Viewer in SharePoint Integrated Mode
When you configure Reporting Services to run in SharePoint Integrated Mode, it’s your choice. You can use either the RSViewerPage or the HTMLViewer to view your reports. The look and feel of the HTML Viewer isn’t as nice as the RSViewerPage interface, but it’s equally functional, and it provides a lot of Url options that can’t be duplicated using the RSViewerPage.

In the HTML Viewer, the report parameter options are displayed at the top of the page (the Report Viewer Web Part shows them on the right-hand side of the report). You can use the HTML Viewer user interface to view the report, change parameters, collapse parameters, zoom, print, export, etc. When you use the HTML Viewer to view your report, you lose the SharePoint UI look and feel, cookie crumb navigation, MySite and MyLinks integration, and Report Builder and Subscriptions integration. You gain the Url options we’ll be discussing later in this post – options that are not supported by the RSViewerPage or the Report Viewer Web Part.

2. Sharepoint Integrated Mode.

In Sharepoint Integrated Mode the reports are dispayed using the RSViewerPage.aspx page thats is located at /_layouts/ReportViewer/RSViewerPage.aspx. This page provides an a SharePoint look and feel, and integrated navigation back to your SharePoint site. It leverages the Report Viewer Web Part to display the report. The Report Viewer Web Part has some very nice features:

An integrated SharePoint look/feel
Cookie crumb navigation back to your site, MySite, and MyLinks
A collapsible parameter panel to the right of the report
1. A nice toolbar with zoom and page navigation
2. An Actions menu on the toolbar, allowing users to: Export to various formats
3. Customize the report using Report Builder Create report subscriptions

To dislay reports in native mode you need to install the Report Viewer and the Report Explorer web part which resides at the following location C:\Program Files\Microsoft SQL Server\90 or 80 \Tools\Reporting Services\SharePoint

To install this web part using command line is as follows

stsadm -o addwppack -filename “(Folder of the cab file)\RSWebParts.cab” -globalinstall

Adding web part and configuring the webpart

1. Open a Web Part page in your SharePoint Web Application
Set your page in edit mode: Site Action -> Edit Page, and click ‘Add a Web Part’ in the zone where you would like to add the Web Part.

2. In the Add Web Parts dialog box, scroll down to Miscellaneous. Select Report Explorer or Report Viewer if you want to add both Web Parts, and then click Add.
Know modify the settings of the Report Web Part. In Report Manager URL, type your URL to a Report Manager instance. By default, a Report Manager URL has the following syntax: http:///reports. For this setting you can also set the Start Path.

3.The Web Parts also allows you to connect the Report Explore to the Report Viewer. This connection can be set in the edit mode of the page:

4. Click on the edit button of the title bar of the Report Explorer Web Part
Point to Connections and follow that up by pointing to ‘Show report in’, and then click ‘Report Viewer’


ramesh said...

I have done the configutation(SSRS reports native mode) using ur article...The reports also displaying in sharepoint..but the problem is it is prompting for credentails..so please let me know how can I achive this..the report has to be displayed with out prompting the credentials.

Raghavendra Shanbhag said...

@Ramesh: I have not tried this but you can look at coding the credentials. Check if this article helps