Export (0) Print
Expand All

Action Properties Dialog Box (Report Builder and SSRS)

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft