Adding a Back Button to a SSRS Drill through Report.

Scenario

You have a Reporting Services report viewed via a browser that has a drill-through to another report. When the drill through report is opened, you would like the user to be able to “jump back” to the previous parent report page. Users can use the browsers back button to do this, but you would like to place a more obvious link on the Report.

Solution

The following report was created using BIDS for SQL Server 2008. The same method can be employed for the 2005 version, though the dialog boxes may appear slightly different.

Open your drill- through report (i.e. the report you will be drilling to, from another ssrs report) and add a text box, which you can format to look like a button, if you wish.

After Adding the Textbox, View its Properties (right-click on textbox).

In the Textbox Properties Dialog box, Select Action, and check “Go to URL”

Enter   javascript:history.back(1) in the entry box, then press OK.

When you deploy the report, and view it in your browser, the user only has to click on the “button” (Go Back)  to be returned to the previous browser page, which would be the parent report.