Report Viewer Web Parts for SharePoint
There are 2 types of Report Viewer Web parts:
1. Web Parts which come with SQL Server Reporting Services
2. Web Parts which come with the Reporting Services Add-in for Sharepoint
Although both these sets of web parts have the same names, they are actually different. The difference between them is that the web parts which come with the add-in will work only with Reporting Services in SharePoint Integrated Mode.
The web parts which come with SQL Server Reporting Services work with Reporting Services in native mode.
The SSRS web parts can be found on the server where Reporting Services is installed. The default location is “C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab”. However these web parts are available in x86. Therefore, on a x64 server, the default location would be “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\ RSWebParts.cab”.
To install these web parts, copy the RSWebParts.cab file on the SharePoint Server and run the following command at the command prompt.
“STSADM.EXE -o addwppack -filename "RSWebParts.cab" -globalinstall”
Refer this link for more details: https://msdn.microsoft.com/en-us/library/ms159772.aspx
The Web Parts which come with the add-in are installed when the add-in is installed. Refer this link for more details: https://technet.microsoft.com/en-us/library/bb326356.aspx
Comments
Anonymous
February 08, 2009
PingBack from http://www.clickandsolve.com/?p=5185Anonymous
August 31, 2011
Thanks for the information. It helped much. Here is what I have tried to extend the report viewer web part and implementation is successful. The main behind is, it should work for all zones in SharePoint. praveenbattula.blogspot.com/.../customize-reportviewerwebpart-in-c-and.htmlAnonymous
February 05, 2012
Nice post. Here’s a tool to use to create and publish your report online in minutes, without coding. You can create different graphs and layouts www.caspio.com/.../reports.aspx