Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
Thursday, June 28, 2018 - click here to learn more
When using the standard Reporting Services drill-through navigation the new report is rendered in the current browser window, therefore overlaying the original report. There is no built in way to indicate you want the drill-through report to open a new window. In a standard web browser you can use the (shift-click) functionality to open the link in a new window, but in Reporting Services this functionality is disabled. So how can you launch a new window when you open a drill-through report?
To get started, let's pop up a simple non parameterized report. Follow these instructions:
- Instead of using the "Jump to Report" option on the Navigation tab, use the "Jump to URL" option.
- Open the expression screen (Fx button).
- Enter the following:
- 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.
See screenshots below.
That's the easy part, ready for a more dynamic approach?
Now, let's say you want to pass a variable to the drill through report. Let's also assume you have a field called ProductCode. Normally, you might hard code that like this:
In this case, you want to pass variables dynamically, using an available value from the source dataset.
You can think of it like this:
The exact syntax in the "Jump to URL" (Fx) expression window will be:
Note - To avoid confusion between double and single quotes, double quotes are in red above.
Notice, that the static portion of the URL is delimited within double quotes.
- Next time you build drill-through report capabilities look at using this method to open a new browser instead of overlaying the original report
- Look at your existing reports to see if this method makes more sense for your report navigation
- Stay tuned for other Reporting Services tips from this author
Last Update: 2007-07-11
About the author
View all my tips