Databases Reference
In-Depth Information
Parameters
First, let's take a look at the parameters that can be used with the rs prefix. The following table lists the
three available values and their uses:
Parameter
Use
The Command parameter is used to send instructions to the
Report Server about the item being retrieved. Available val-
ues return the report item and set session timeout values.
Command
The Format parameter is used when rendering reports. Any
rendering formats available on the report server can be
passed using this parameter.
Format
The Snapshot parameter is used to retrieve historical report
snapshots. Once a report has been stored in snapshot his-
tory, it is assigned a time/date stamp to uniquely identify
that report. Passing this time/date stamp will return the
appropriate report.
Snapshot
Now that you have seen the different rs parameters, let's take a look at some of their available values.
Command Parameter
The Command parameter is your main parameter for setting the output of a given report item. It can also
be used for resetting a user's session information, which guarantees that a report is not rendered from the
session cache. Here is a listing of the possible values that can be passed to the Command parameter:
Value
Use
The GetDataSourceCredentials command can be
used to return data source information in an XML format.
You can use this parameter on shared data sources.
GetDataSourceCredentials
This command returns the binary of your Reporting
Services resources, such as images, via the URL.
GetResourceCredentials
Used in combination with a Reporting Services folder.
This lets you view all the items in a given folder.
ListChildren
Allows you to render the report using the URL. Probably
the most frequently used command.
Render
Can be used to refresh a user's session cache. Because
Reporting Services works typically via HTTP, it is crucial
for the server to maintain state information about the user.
However, if you want to ensure that a report is executed
each time the user views a report, this state information
needs to be refreshed. Use this parameter to reset the
user's session and remove any session cache information.
ResetSessionTimeout
Search WWH ::




Custom Search