SSRS URL

SSRS url parameters are of two types:
1) parameter prefixed with rs: are directed to the report server.
2) parameter prefixed with rc: are directed to an HTML Viewer

Reference: http://msdn.microsoft.com/en-us/library/ms152835(v=sql.110).aspx

How did we use it today for rendering the report in Excel:
Globals!ReportServerUrl + “?” + Globals!ReportFolder+ “/” + “abc.rdl&rs:Command=Render&rs:Format=Excel&param1=” & Parameters!param1.Value & “&param2=” & Parameters!param2.Value
http://aaa.xxx/abc.rdl&rs:Command=Render&rs:Format=Excel&param1=param1value&param2=param2value

Some more sample to clarify the point:

For example in Native mode, to display page 2 of the report.
http://myrshost/reportserver?/Sales&rc:Section=2
For example in SharePoint mode, to display page 2 of the report.
http://myspsite/subsite/_vti_bin/reportserver?http://myspsite/subsite/Sales&rc:Section=2

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s