Action Properties Dialog Box (Report Builder and SSRS)

  • Article

The Action dialog box can be used to enable hyperlink options for a chart, gauge, and map elements that support links. Define an action so that a user can click on the report and link to a URL, to a different report on the same report server or on a SharePoint site that is integrated with a report server, or to a different location in the same report.

Options

  • Enable as an action
    Select an option to indicate the action to perform when the user clicks the item.

  • None
    Choose this option to indicate that the item has no action.

  • Go to report
    Choose this option to create a link to a drillthrough report that is located on a report server. The following additional options appear when you select Go to report.

    • Specify a report
      Type or select the name of the report that you want to use as a drillthrough report. Drillthrough reports must be on the same report server as this report.

      For a report published to a report server configured for native mode, use a full or relative path without the file name extension. If the report is in the same folder as the current report, use the name of the report only. If the report is in a different folder on the same report server, use a relative path or a full path. A relative path starts from the current folder and moves up the folder hierarchy, for example, ../Folder2/Report1. A full path starts from /, the Home folder. For example, /Reports/Report1.

      For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL including the file name extension (.rdl). For example, http://<SharePointservername>/<site>/Documents/Report1.rdl. Relative paths are not supported.

      For more information, see Specifying Paths to External Items (Report Builder and SSRS) in the Report Builder documentation on msdn.microsoft.com.

    • Use these parameters to run the report
      Add a list of parameters to pass to the drillthrough report. The parameter names must match the parameters defined for the target report. Use the Add and Delete buttons to add and remove parameters and use the up and down arrows to order the list of parameters.

    • Add
      Add a new parameter to pass to the drillthrough report.

    • Delete
      Delete a parameter for the drillthrough report.

    • Up arrow
      Move the parameter up in the list.

    • Down arrow
      Move the parameter down in the list.

    • Name
      Type text that is the name of a parameter defined in the drillthrough report.

    • Value
      Type or select a value to pass for the named parameter in the drillthrough report. Click the Expression (fx) button to edit the expression.

    • Omit
      Select to prevent the parameter from running. By default, this check box is cleared and not active. To select the check box, click the Expression (fx) button and either type True or create an expression. The check box is selected when you click OK in the Expression dialog box.

  • Go to bookmark
    Choose this option to define a link to a bookmark in the current report. The following additional option appears when you select Go to bookmark.

    • Select bookmark
      Type or select the bookmark ID for the report to jump to when the user clicks the link. Click the Expression (fx) button to change the expression. The bookmark ID can be either a static ID or an expression that evaluates to a bookmark ID. The expression can include a field that contains a bookmark ID.

      To link to a bookmark, you must first set the Bookmark property of a report item. To set the Bookmark property, select a report item, and in the Properties pane, type a value or expression for the bookmark ID; for example, SalesChart or 5TopSales.

  • Go to URL
    Choose this option to define a link to a Web page. Type or select the URL of a Web page or an expression that evaluates to the URL of a Web page. Click the Expression (fx) button to change the expression. This expression can include a field that contains a URL. The following additional option appears when you select Go to URL.

    • Select URL
      Type or enter the URL of the item. For an item published to a report server configured for native mode, use a full or relative path. For example, http://<servername>/images/image1.jpg. For an item published to a report server configured in SharePoint integrated mode, use a fully qualified URL (for example, http://<SharePointservername>/<site>/Documents/images/image1.jpg).

      You can pass parameters in a report URL. For more information, see Pass a Report Parameter Within a URL and URL Access Parameter Reference.

See Also

Tasks

Add a Subreport and Parameters (Report Builder and SSRS)

Concepts

Charts (Report Builder and SSRS)

Report Builder Help for Dialog Boxes, Panes, and Wizards

Report Parameters (Report Builder and SSRS)

Interactive Sort, Document Maps, and Links (Report Builder and SSRS)