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.
  1. Copy the to a folder on the SharePoint server. By default the can be found in "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint".
  2. On the SharePoint Server run the STSADM command on the file using the following syntax "STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\" -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.

Hope this helps you!!!

No comments:

Post a Comment