Export (0) Print
Expand All
Expand Minimize

Series Properties Dialog Box, Action

SQL Server 2008

Select Action on the Series Properties dialog box to set drillthrough actions for this series. Any actions specified will apply for all data points in the series.

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

Community Additions

ADD
Show:
© 2014 Microsoft