Export (0) Print
Expand All

Using a URL to Access Report Server Items

The way in which the report server responds to a URL request depends on the type of item supplied in the URL. The following sections describe how the report server responds to URL requests for different types of items.

If a report is referenced in a URL, the report runs and is rendered based on the parameters supplied in the URL. If you do not include the parameter string rs:Command=Render or other parameters in the URL, the report is displayed in HTML Viewer. The format of the report depends on your browser and browser version. For more information, see Finding and Viewing Reports in Report Manager.

ms154497.note(en-US,SQL.90).gifNote:
If you omit the line rs:Command=Render, the report server must evaluate the item type and select the appropriate command value. Use rs:Command=Render in the URL to improve the performance of the report server.

If a resource is referenced in a URL, the resource is returned. You can access and view images and other resources in your browser by using a URL. If a resource is not compatible with your browser, you may be prompted to open or save the file or resource to disk.

If a data source is referenced in a URL, the data source is displayed if you are an authenticated user with Read Contents permission on the data source. Accessing a data source in this way is similar to calling the Web service GetDataSourceContents method.

When you access the data source, the XML representation of the DataSourceDefinition property of the data source appears in browsers that support XML. The DataSourceDefinition 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=AdventureWorks;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.

ms154497.note(en-US,SQL.90).gifNote:
To improve server performance, include the line rs:Command=GetDataSourceContents immediately after the path to the shared data source.

If a folder is referenced in a URL, a generic folder-navigation page is returned. The HTML page contains links to the subfolders, reports, data sources, and resources contained in the requested folder. 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. The format of the version number might look similar to the following example:

"Microsoft SQL Server Reporting Services Version 9.00.0xxx.00"

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft