Share via

  • Article

Calculated Series Properties Dialog Box, Action

Select Action on the Calculated Series Properties dialog box to set drillthrough actions for this calculated series.

Options

  • Enable as a hyperlink
    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.

  • Select a report from the list
    Type or select the name of the report that you want to use as a drillthrough 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 to the report (for example, .../Folder2/Report1). If the report is on a different report server, use the full path to the report server and report (for example, http://server1/Folder3/Report2).

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

  • 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 listed parameter.

  • Name
    Type 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 exclude the parameter.

  • Go to bookmark
    Choose this option to define a link to a bookmark in the current report.

  • 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.

  • Go to this URL
    This option is displayed when Go to URL is selected. Type 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).