• Article

How to: Add a Drillthrough Action on a Report (Reporting Services)

A report can contain links to other reports. The report that opens when you click the link in the main report is known as a drillthrough report. Drillthrough reports must exist on the same report server as the main report, but they can be in different folders. You can add a drillthrough link to any item that has an Action property, such as a text box, an image, or data points on a chart. For more information, see the Action page topics in Report Designer F1 Help.

To add a drillthrough action

  1. In Design view, right-click the text box, image, or chart to which you want to add a link and then click Properties.

  2. In the Properties dialog box for that report item, click Action.

  3. Select Go to report. Additional sections appear in the dialog box for this option.

  4. In Select a report from the list, type or select the name of the report you want to jump to.

    Note

    The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative path from this report or an absolute path to the report on the server. An example of a relative path is …\DrillthroughReport\Store. An example of an absolute path is \SalesReports\DrillthroughReport\Store.

    On a report server configured in native mode, specify a drilthrough report name without the file extension .rdl.

    On a report server configured in SharePoint integrated mode, you must specify the report name in an expression and include the file extension .rdl. For example, ="http://site/subsite/Documents/DrillthroughReport.rdl".

    If you have to specify parameters for the drillthrough report, follow the next step.

  5. In Use these parameters to run the report, click Add. A new row is added to the parameter grid.

    • In the Name text box, type the name of the report parameter in the drillthrough report. If the drillthrough report is in the Report Server project, the parameter names are available in the drop-down list.

      Note

      The names in the parameter list must match the expected parameters in the target report exactly. If the names do not match, or if an expected parameter is not listed, the drillthrough report fails.

    • In Value, type or select the value to pass to the parameter in the drillthrough report.

      Note

      Values can contain an expression that evaluates to a value to pass to the report parameter. The expressions in the value list include the field list for the current report.

  6. To test the link, run the report and click the report item that you set this link on. For text boxes, it is helpful to change the color and effect of the text to indicate to the user that the text is a link. For example, change the color to blue and the effect to underline by setting the Font properties in the Text Box Properties dialog box.