DRAG DROP
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.)
Answer: See the explanation.
Explanation:
Box 1:
Box 2:
Box 3:
Box 4:
Note:
* Select Action on the Text Box Properties dialog box to enable hyperlink options for the text
box.
* 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.
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00917.jpg
Generally it is always better to encode all the strings if you use Action Go to URL. But here we will create a link with email address, that would not have any special characters. So we can skip this.
Additionaly to use UrlEncode function you need to add reference to System.Web assembly. It was not told in the question, we have imported this earlier.
Nice description of URLEncode in SSRS:
http://capstonebi.blogspot.com/2010/04/url-encoding-in-reporting-services.html