This documentation is archived and is not being maintained.
Action Properties Dialog Box
SQL Server 2008 R2
The Action dialog box can be used to enable hyperlink options for placeholder text, a text box, image, or an element of a chart, gauge, or map that support links. To open this dialog box, select the item on the report design surface, and in the Properties pane, click the ellipsis (...) next to Action.
Select an option to indicate the action to perform when the user clicks the item.
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. 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.
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 a new parameter to pass to the drillthrough report.
Delete a parameter for the drillthrough report.
Move the parameter up in the list.
Move the parameter down in the list.
Type text that is the name of a parameter defined in the drillthrough report.
Type or select a value to pass for the named parameter in the drillthrough report. Click the Expression (fx) button to edit the expression.
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
Create a link to a bookmark in the current report.
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.
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.
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).