You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet si

Sequence of actions (as shown in the solution image, although the question text states 'four actions' and six steps are depicted): 1. Open the Text Box Properties window of the EmailAddress detail text box. 2. Select the Action page. 3. In the box, enter the ="mailto:" & Fields!

Build reports

Question

You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site. The report consists of a single table. The design of the table is shown in the following diagram. You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Explanation

Sequence of actions (as shown in the solution image, although the question text states 'four actions' and six steps are depicted):

Open the Text Box Properties window of the EmailAddress detail text box.
Select the Action page.
In the box, enter the ="mailto:" & Fields! EmailAddress.Value expression.
Select the General page.
Select the Go to URL option.
Select the Go to Bookmark option.

Additional details from the text explanation:

Select Action on the Text Box Properties dialog box to enable hyperlink options for the text box.
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.

Topics

#SSRS action properties#email action#text box configuration#Report Designer

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice