Sunday, November 2, 2014

SSRS native mode reports and SharePoint 2010

I am now developing SSRS reports which will be hosted on native mode. These SSRS reports will be consumed by SharePoint 2010 applications. To consume native mode SSRS reports please follow the below steps.

Copy the RSWebParts.cab to a folder on the SharePoint server. By default the RSWebparts.cab can be found in "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint".

On the SharePoint Server run the STSADM command on the RSWebParts.cab file using the following syntax "STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall". -globalinstall is must if you want to create connected web parts.

After these you will be able to use Report Viewer web parts, which are under miscellaneous categories.