Display Reporting Services drill through reports in new browser

Solution

Use a little javascript with a customized URL in the “Jump to URL" option of the Navigation tab.

To get started, let’s pop up a parameterized report.

Follow these instructions:

1.                  Instead of using the “Jump to Report" option on the Navigation tab, use the “Jump to URL" option.

2.                  Open the expression screen (Fx button).

3.                  Enter the following:

=="javascript:void(window.open(‘http://ServerName/ReportServer/Pages/ReportViewer.aspx?%2fReportFolder%2fReports%2fReportName&rs:Command=Render:Parameters=true&Param1=” & Parameters!Param1.Value & "&Param2=" & Parameters!Param2.Value &"&Param3=" & Parameters!Param3.Value & "&Param4=" & join(Parameters!Param4.Value,"&Param4=") & ”’))"

Click OK twice, then save and deploy the report.

Note: The link will not work from the designer environment. You must deploy the report (hopefully to a test area) to try the link.