Drilling Down to a Report in a new tab SSRS Integrated Mode

There are two ways to navigate to another SSRS from a main Report

  1. Action “Go to Report”
  • Right-click on a TextBox, select Text Box Properties, select Action tab and select option “Go to report”.

GoToReport

  • Click on “Browse” and select the SSRS Report from the report library.
  • If the selected SSRS Report has parameters, click on “Add” to add parameter. From the “Name” dropdown select the parameter name and from the “Value” dropdown select the value to pass to the parameter.
  1. Action “Go to URL”: This option is ideal to open a SSRS report in a new tab
  • Right-click on a TextBox, select Text Box Properties, select Action tab and select option “Go to URL”.

GoToURL

  • Click on “fx” button under “Select URL”
  • Type the URL of the report in the following format

= “<PWASiteURL>/_vti_bin/reportserver? <PWASiteURL>/ <relativeSSRSURL>&<ParameterName>=<ParameterValue>”

Example of a link to a report named “Project Overall Status”

=LCase(Globals!ReportServerUrl) & “?” & Replace(LCase(Globals!ReportServerUrl),”/_vti_bin/reportserver”,””) & “/ProjectBICenter/SSRS Reports Library/Project Overall Status.rdl&ParmProjectName=” & LCase(Fields!ProjectUID_STR.Value)

The built in field Globals!ReportServerUrl returns the URL where the report is rendered.

  • If you want the report to open in a new tab, add the JavaScript function window.open

Type the URL of the report in the following format

=”javascript:void(window.open(‘<PWASiteURL>/_vti_bin/reportserver? <PWASiteURL>/ <relativeSSRSURL>&<ParameterName>=<ParameterValue> ‘,’_blank’));”

Example of a link to a report “Project Overall Status” in DEV environment with the JavaScript code

=”javascript:void(window.open(‘” & LCase(Globals!ReportServerUrl) & “?” & Replace(LCase(Globals!ReportServerUrl),”/_vti_bin/reportserver”,””)  & “/ProjectBICenter/SSRS Reports Library/Project Overall Status.rdl&ParmProjectName=” & LCase(Fields!ProjectUID_STR.Value) & “‘,’_blank’));”

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