View and Explore Native Mode Reports Using SharePoint Web Parts (SSRS)
Applies To: SQL Server 2016
Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes.
Native mode: If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts Report Explorer and Report Viewer that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic.
SharePoint mode: If you want to access a report server that runs in SharePoint mode, use the web parts that are installed by the Reporting Services Add-in for SharePoint products. For more information about the add-in, see Where to find the Reporting Services add-in for SharePoint Products.
For more information about report server modes, see Reporting Services Report Server.
In this topic:
Report Explorer and Report Viewer are SharePoint 2.0 Web Parts that were introduced in SQL Server 2000 Reporting Services Service Pack 2 (SP2) and continue to be available in current releases.
The Web Parts provide a way to view reports and explore the report server folder hierarchy from a SharePoint site.
Note that customizing the Web Parts is not supported. The Web parts are intended to be used as is, and should not be extended or modified.
Report Explorer (SPExplorer.dwp) connects to Report Manager on the report server computer. You can browse available reports on a report server and subscribe to individual reports. If Report Builder is enabled and you have sufficient permissions, you can start Report Builder from the Report Explorer Web Part.
Report Explorer displays the contents of a folder using a page in Report Manager. Access to individual items and folders throughout the report server folder hierarchy are controlled through role assignments on the report server. When you select a report, it opens in a new browser window. The HTML viewer on the report server displays the report and provides the report toolbar, not the Report Viewer Web Part. If you want to customize the toolbar settings, be sure to specify the URL access parameters on the report server. For instructions, see URL Access Parameter Reference.
Report Viewer (SPViewer.dwp) displays a report and provides a toolbar that you can use to navigate pages, search for content, or export the report. You can add the Report Viewer Web Part to a Web Part page to always show a specific report on that page or you can connect it to Report Explorer to display reports that are opened through that Web Part.
Requirements for using the Report Viewer and Report Explorer Web Parts include the following:
Supported versions of SharePoint products and technologies are:
Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007.
SharePoint Foundation 2010 and SharePoint Server 2010.
The Native mode report server version must be SQL Server 2005 Reporting Services or later.
The report server must run in native mode. You cannot use the Report Explorer and Report Viewer Web Parts to connect to or view reports on a report server that runs in SharePoint mode..
Report Manager must be installed.
Report Explorer and Report Viewer Web Parts are distributed through a cabinet (.cab) file that is included with Reporting Services. Instructions for installing, configuring, and using the Web Parts are provided in the following sections of this topic.
Web parts are delivered to a SharePoint server as a cabinet (.cab) file. Run the SharePoint Stsadm.exe tool on the .cab file from the command line to install the Web Parts. To learn more about the tool and Web part deployment see your SharePoint documentation.
Copy the RSWebParts.cab to a folder on the SharePoint server. You can copy it to any folder on the SharePoint server, and then delete it later after you install the Web Parts. By default SQL Server 2016Reporting Services installs the RSWebParts.cab file into the following folder:
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Reporting Services\SharePoint
On the computer that has the installation of the SharePoint product, open SharePoint 2010 Management Shell with administrative privileges.
Run the following PowerShell command:
Install-SPWebPartPack -LiteralPath "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Reporting Services\SharePoint\RSWebParts.cab" -GlobalInstall
You should see a message similar to the following, indicating the Web Part was deployed.”
Name SolutionId Deployed
---- ---------- --------
rswebparts.cab 00000000-0000-0000-0000-000000000000 True
For more information on using PowerShell, see Install-SPWebPartPack (http://technet.microsoft.com/library/ff607840.aspx).
Copy the RSWebParts.cab file to the same location on the SharePoint server as described in the PowerShell section of this document.
On the computer that has the installation of the SharePoint product, open a Command Prompt window with administrative privileges and navigate to the folder that has the Stsadm.exe tool. The default path for SharePoint Foundation 2010 is the following:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN.
Run Stsadm.exe on the .cab, using the following syntax:
STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall
You should see a message of “Operation completed successfully.”
-globalinstalladds the Web Parts to the global assembly cache (GAC). This step is necessary if you want to connect the Web Parts.
After you install the Web Parts, you can add them to one or more web pages on a SharePoint site. You must have permission to create Web sites and add content.
The following procedure will add both web parts to a page and then connect Report Explorer and Report Viewer together so when you click a report in Report Explorer, it will be displayed inside Report Viewer.
In Site Actions, click Edit Page.
In a zone on the page, click Add a Web Part.
In the Add Web Parts dialog box, scroll down to the Miscellaneous category.
Select Report Viewer.
Do not select SQL Server Reporting Services Report Viewer That Web Part is registered when you install the Reporting Services Add-in for SharePoint products, and is used for running a report server in SharePoint mode. It cannot be used to view reports on a native mode report server.
While the page is in edit mode, click Edit Web Part in the Report Viewer Web Part.
In Report Manager URL, type a URL to a Report Manager instance that is associated with the native mode report server you want to access. By default, a Report Manager URL has the following syntax: http://<servername>/reports.
In Report Path, specify a forward slash, followed by the folder path, and the report name. Do not include the server name or Report Manager virtual directory. For example to open the ‘Company Sales’ report in the Adventure Works folder specify /Adventure Works/Company Sales. The following is another example where the report ‘Products’ is in the report server root folder /Products.
In another zone of the page, click Add a Web Part and from the miscellaneous folder, click Report Explorer and click Add.
In the Report Explorer Web Part context menu, click Edit Web Part.
In Report Manager URL, type a URL to a Report Manager instance that is associated with the native mode report server you want to access.
Optionally, set the Start Path. The start path is a folder in the report server folder hierarchy. You can specify a start path if you want the default page to be a folder further down the folder hierarchy. The path must begin with a forward slash. You must specify a complete path that starts with the root node of the report server folder hierarchy, but does not include the server name or Report Manager virtual directory. For example, to open a folder named Adventure Works just below the root node, specify /Adventure Works in the Start Path.
The Report Explorer will show a list of the report items in the report server. By default, if you click the name of a report, it will open the report in a new window. Complete the following steps if you want to connect the Report Explorer to Report Viewer so when you click a report name in Report Explorer it is displayed in Report Viewer.
In the Report Explorer context menu, click Connections.
Click Show report in.
Click Report Viewer.