How to: Add a Drillthrough Report Link (Report Designer)
This documentation is archived and is not being maintained.

How to: Add a Drillthrough Report Link (Report Designer)

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

  2. On the Navigation tab, select Jump to Report.

  3. Type or select a report name.

    ms159847.note(en-US,SQL.90).gifNote:
    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 or absolute path to the report.

  4. To set parameters to pass to the drillthrough report, click Parameters, and then do the following:

    • In Parameter Name, type the names of the report parameters in the drillthrough report.
      ms159847.note(en-US,SQL.90).gifNote:
      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 Parameter Value, type or select the values to pass to the parameters in the drillthrough report.
      ms159847.note(en-US,SQL.90).gifNote:
      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.

Show:
© 2016 Microsoft