Home > SSRS > SSRS URL Reporting Tips

SSRS URL Reporting Tips

URL Reporting:-

1)      Hide Parameter in your browser:-

Add as &rc:Parameters=false

URL: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTestReport%2fUrl_REPORT&rs:Command=Render&rc:Parameters=false

Note: When you don’t give the values to the parameter used and setting display of parameter off it will throw error as shown below:-

ParameterFalse

After giving the value to the parameter, it will show report with no parameter selection on top of report as shown in below screen.

URL: http://Localhost/ReportServer/Pages/ReportViewer.aspx?%2fTestReport%2fUrl_REPORT&rs:Command=Render&rc:Parameters=false&Country=1

ParameterFalseReportShowing

2)      Multiple Value Parameters:

Add that parameter multiple times with different values in the URL

URL: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTestReport%2fUrl_REPORT&rs:Command=Render&rc:Parameters=false&Country=1&Country=3

MultipleValue

3)      Access the Nth Page from URL

Add &rc:Section=5 (if 5th Page want to accessed)

URL: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTestReport%2fUrl_REPORT_Pageination&rs:Command=rENDER&rc:Parameters=false&Country=1&rc:Section=5

URL_Section

4)      Export To EXCEL or PDF

Add &rs:Format=Excel

URL:

http://Localhost/ReportServer/Pages/ReportViewer.aspx?%2fTestReport%2fUrl_REPORT_old&rs:Command=rENDER&rc:Parameters=false&Country=1&rs:Format=Excel

ExportURL

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: SSRS Tags: ,
  1. February 15, 2015 at 3:07 am

    Reblogged this on Dinesh Ram Kali..

  1. No trackbacks yet.

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

%d bloggers like this: