Access Report Server Items Using URL Access
This topic describes how to access catalog items of different types in a report server database or in a SharePoint site using rs:Command=Value. It is not necessary to actually add this parameter string. If you omit it, the report server evaluates the item type and selects the appropriate parameter value automatically. However, using the rs:Command=Value string in the URL improves the performance of the report server.
_vti_bin proxy syntax in the examples below. For more information about using the proxy syntax, see URL Access Parameter Reference.
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
Access a Report
To view a report in the browser, use the rs:Command=Render parameter. For example:
It is important the URL include the
_vti_bin proxy syntax to route the request through SharePoint and the Reporting Services HTTP proxy. The proxy adds some context to the HTTP request, context that is required to ensure proper execution of the report for SharePoint mode report servers.
Access a Resource
To access a resource, use the rs:Command=GetResourceContents parameter.If the resource is compatible with the browser, such as an image, it is opened in the browser. Otherwise, you are prompted to open or save the file or resource to disk.
Access a Data Source
To access a data source, use the rs:Command=GetDataSourceContents parameter. If your browser supports XML, the data source definition is displayed if you are an authenticated user with Read Contents permission on the data source. For example:
The XML structure might look similar to the following example:
<DataSourceDefinition> <Extension>SQL</Extension> <ConnectString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks2012;Data Source=MYSERVER1;</ConnectString> <CredentialRetrieval>Integrated</CredentialRetrieval> <WindowsCredentials>False</WindowsCredentials> <ImpersonateUser>False</ImpersonateUser> <Prompt /> <Enabled>True</Enabled> </DataSourceDefinition>
The connection string is returned based on the SecureConnectionLevel setting of the report server. For more information about the SecureConnectionLevel setting, see Using Secure Web Service Methods.
Access the Contents of a Folder
To access the contents of a folder, use the rs:Command=GetChildren parameter. A generic folder-navigation page is returned that contains links to the subfolders, reports, data sources, and resources in the requested folder. For example:
The user interface you see is similar to the directory browsing mode used by Microsoft Internet Information Server (IIS). The version number, including the build number, of the report server is also displayed below the folder listing.