Previous Topic  Next Topic

Adding Links in Reports

You can add links in a report to link the report with other reports, locations specified by URLs, e-mail addresses, or Blob data type fields. In this way, the users of the report can gain access to the linked targets by selecting the corresponding trigger objects in the report. The links can either be simple links or conditional links. Using conditional links, you can make different targets loaded based on different conditions. This topic describes the methods you can use to add links in a report.

You can use the following objects as the trigger objects of links: labels, data fields (DBFields, summary fields, formula fields, parameter fields), special fields, images, areas in shape maps, and the category/series axis, legend, and data markers in charts.

This topic contains the following sections:

• Adding Links in a Report
  • Linking to Another Report
  • Linking to a Detail Report
  • Linking to a URL
  • Linking to an E-mail
  • Linking to a Blob Data Type Field
• Editing the Links in a Report
• Removing Links from a Report
• Example of Adding a Conditional Link

Adding Links in a Report

To add a simple link in a report:

1. Right-click the object used as the trigger object of the link and select Link on the shortcut menu.
2. In the Insert Link dialog box, select the target to which the trigger object is linked: Report, Master/Detail Report, URL, E-mail, or Content from the Link Type drop-down list.
3. Specify the options for the link target.
4. Select OK to create the link.

To add a conditional link in a report:

1. Right-click the object used as the trigger object of the link and select Link on the shortcut menu.
2. In the Insert Link dialog box, select the Conditional Link checkbox.

   

3. Select the Add button . Designer displays the Edit Conditions dialog box.

   

4. Select the Add Condition button to add a condition line.
5. From the field drop-down list, select the field on which the condition is based.
6. Choose the operator with which to compose the condition expression from the operator drop-down list.
7. From the value drop-down list, specify the value of how to build the condition. You can also type in the value manually.

   You can specify an empty string as the value for a field of String type, by simply leaving the text box blank (value length=0). If you would like to filter space string (one or more spaces) as well as empty string, create a formula with the statement Trim(@Field) which transforms the spaces into empty string, then use the formula to replace the field itself on which the condition is based.

8. Repeat steps 4 to 7 to add more condition lines and define the logic relationship between the condition lines: "And", "Or", "And Not", or "Or Not".

   To group some condition lines, select them and select the Group button, Designer then adds the selected condition lines in one group and applies them as one line of filter expression (you can also group conditions and groups together); to take out any condition or group from a group, select it and select Ungroup; to adjust the priority of the condition lines, select it and select the Up or Down button; to delete a condition line, select it and select the Delete button.

9. Select OK to save the condition.

   Designer then displays the newly added condition and highlights it in the conditions box in the Insert Link dialog box.

10. From the Link Type drop-down, select the target to which the trigger object is linked under this condition: Report, Master/Detail Report, URL, E-mail, or Content, then specify the options for the link target.
11. Repeat the above steps to add more conditions and define the target for each condition.

    To edit a condition, select the condition, select the Edit button , then edit it in the Edit Conditions dialog box.

    To adjust the priority of the conditions, select a condition and select the Move Up or Move Down button.

    To delete a condition, select the condition and then select the Remove button .

12. Select the Others checkbox and define a target to which the trigger object is linked when none of the conditions you have specified are met.

13. Select OK to create the conditional link. See Example of Binding a Conditional Link for more information.

• You cannot add conditional links on objects the parents of which are not bound with datasets.
• By default, the link action has the highest select priority at runtime. You can change the priority by setting the report's Click Priority property.

Linking to Another Report

In most cases, your reports are affiliated with one another, with each report emphasizing one or more aspects of a bigger picture. You can set up relationships for the report users to browse from one report to another through the relationship "channels", thus you can achieve an inter-report relationship network by setting up the link conditions between two reports in the same catalog.

To link a report to another report:

1. In the Insert Link dialog box, select Report as the link type.

   

2. If the primary report is a page report, select the Browse button to specify the page report in the same catalog that contains the report tab you want as the linked report, then select the report tab name from the Report Tab drop-down list.

   If the primary report is a web report or a library component, select the Browse button to specify the web report in the same catalog that you want as the linked report.

3. From the Target drop-down list, select where you want to load the linked report.

   Logi Report Engine applies the specified target only when the report users trigger the link in Page Report Studio or Web Report Studio; when the report users trigger the link in JDashboard, except for Same Frame, Logi Report Engine treats all the other targets as New Window.

4. Select the More button to display more options for setting the link.
5. In the Filter tab, select above the Components box.
6. In the Choose Component dialog box, add the data components in the linked report that you want to interlink with the primary report. If the required data components use different datasets, you need to add them respectively; however, you can add them all at a time as long as the data components are based on the same dataset.

   

7. Specify the filter conditions based on which to set up the link relationship between the primary report and the selected data components in the linked report (linked data components). However, depending on where the trigger object is in the primary report, you are not able to define filter conditions under some circumstances. For example, if the trigger object is a label in the report body, you can find that Designer does not enable the Add button above the Field Conditions box.

   

   1. From the Components box, select a linked data component.
   2. Select above the Field Conditions box to add a condition line.
   3. Select the primary field from the field drop-down list in the Fields (Primary) column. You can select from all the data fields in the current catalog which are valid to the data resource used by the data component that contains the trigger object.

      When the trigger object is one of the following, Designer displays the item Current Field in the Fields (Primary) drop-down list. Select it if you want to use the data field that is related to the trigger object in the filter condition.

      • A data field in a crosstab.
      • A DBField, formula field, summary field, or the special field Group Name in a banded object or table.
      • The chart legend which is bound with the category/series field of a chart, or the category/series axis of a chart.
   4. Choose an operator from the drop-down list in the OP column.
   5. Select the linked field from the field drop-down list in the Fields (Linked) column, which contains data fields in the current catalog that are valid to the data resource used by the linked data component and are of the same data type as the selected primary field.

      When you select Current Field in the Fields (Primary) drop-down list, if the dataset of the linked data component contains the data field, which is of the same data type and the same name as the data field that is related to the trigger object in the primary report, Designer displays the item Corresponding Field in the Fields (Linked) drop-down list. You can select it to use this corresponding field in the linked data component in the filter condition.

      When you define a filter condition as Current Field = Corresponding Field, the report users are able to set up dynamic links with filters automatically generated from the drilling path at runtime. For example, if the data field related to the trigger object in the primary report is the group object Country, which is contained in a hierarchy and its one-level-lower group is City, after the report users drill from Country down to City in the primary report and trigger the link on any city, they get data of the specified city in the linked data component.

   6. You can specify more conditions by selecting and then specifying the primary field, the operator, and the linked field. The relationship between these conditions is "AND", which means that Logi Report Engine fetches data for the linked data component which meets all of the conditions.

      To delete an unwanted condition, select it and select .

   7. Repeat the above steps to set link conditions between the primary report and other linked data components.
8. Specify whether to apply the on-screen filters (filters created via filter controls) in the primary report to the selected data components of the linked report (linked data components).

   

   1. From the Components box, select a linked data component.
   2. Select Pass on-screen filters to the linked components.
   3. When the data component containing the trigger object in the primary report and the linked data component use different data resources, Designer enables the Mapping Table button. In this case, you need to select the button to define the mapping relationship based on which to pass the on-screen filters in the primary report to the linked data component using the Mapping Table dialog box.

      

   4. Select to add a mapping line.
   5. From the drop-down list in the Fields (Primary) column, select the field that is bound with a filter control in the primary report.
   6. In the drop-down list in the Fields (Linked) column, Designer then lists the available fields in the data resource used by the linked data component which are of the same data type as the selected filter control field. Select a field whose values are the same as those of the filter control field.

      A mapping relationship is now set up. When the link is triggered, Logi Report Engine applies the corresponding on-screen filter in the primary report to the selected linked field in the linked data component.

   7. Add more mapping lines and define the mapping relationship between the filter control fields in the primary report with appropriate fields in the linked data component.

      To delete an unwanted mapping line, select it and select .

   8. Select OK to go back to the Insert Link dialog box.
   9. Repeat the above steps to apply the on-screen filters in the primary report to other linked data components.
9. From the Default Linked Component drop-down list, select the data component that displays by default in the linked report when the link is triggered in the exported results.

   For example, a linked report contains a chart and a table and you select the table as the default linked component. When you export the primary report to PDF with linked report and trigger the link in the PDF output, the page that contains the table displays by default. You can scroll to view the chart.

10. Designer enables the Parameters tab if the linked report contains one or more parameters. In this tab, you can assign fields of the primary report to parameters of the linked report to use the field values for the parameters automatically when running the linked report from the link. If you select a parameter field, you can choose Current Value to use its most recently specified value or Initial Value to use its original value for the parameter in the linked report.

    

11. If you would like to pass the values of the filter objects like filter controls in the primary report to filter objects in the linked report, go to the Advanced tab to set up the relationship between the filter objects as follows (Designer disables the Advanced tab if you are adding link in a library component):

    

    1. Select to add a mapping line.
    2. Select the ellipsis button in the Primary Report Property/Object column, then in the Select Value dialog box, select a filter object in the primary report and select OK.

       

       Designer lists all the objects in the primary report in the Select Value dialog box but you can only select filter controls from the object tree.

    3. In the Linked Report Property/Object column, select to select a filter object in the linked report. You need to make sure that values of the filter object in the primary report can be applied to the filter object in the linked report in the same line.
    4. Follow the above steps to set up the relationship between more filter objects in the primary report and linked report.
12. Select Pass style group information down to the linked report to transfer style information from the primary report to the linked report, so as to apply the style of the primary report to the linked report.
13. Select OK to apply the settings.

Then, when the report users run the primary report at runtime and select the trigger object, they can get the linked report which displays according to the specified link conditions. The report users can also trigger the link when viewing the report in HTML, PDF, or Excel if they select the Run Linked Report option while specifying the settings of the corresponding format.

• You can only link a page report with another page report, and a web report with another web report. For a library component, you can link it with a web report only.
• When linking reports, you need to avoid link loops. For example, if you have linked report A to report B, you cannot link report B back to report A again.
• The conditions specified in the Filter tab are used for filtering when the link is triggered at runtime, that is, the linked report only displays the data that meets the conditions; however, when the link is triggered in HTML, PDF, or Excel output, the conditions are used for setting up search criteria between the two reports, which means after you select the trigger object in the primary report, the linked report displays the page that contains the data satisfying the conditions.
• When you specify the filter condition between the primary report and linked report as Current Field = Corresponding Field, at runtime, Logi Report Engine ignores the condition if there isn't a matched corresponding field in the linked report, which means after the report users trigger the link, they get a linked report which is not filtered. In the meantime, Logi Report Engine adds an error message into log to record the issue.

Linking to a Detail Report

You can join reports in the same catalog together in order to create a master/detail report group. Usually, the master report holds comprehensive data, while the detail reports hold related detailed information. You can gain access to the detail reports by selecting triggers. A detail report can also be the master report of another report. In this way, you can set up more pairs of master/detail reports, where many reports are joined together, eventually leading to the formation of a report chain. However, in a master/detail report group, you cannot use crosstab reports as the master.

The main advantage of using a master/detail relationship is the report users can browse though the details by selecting next detail and previous detail without going back to the master report. When the report users do go back to the master report, they see the master report based on the last detail report that they have viewed. The detail report supports all the page report operations, such as Sort, Filter, Drill, and Search.

You can only apply the Master/Detail Report link type in page reports that use query resources.

To make a report linked to a detail report:

1. In the Insert Link dialog box, select Master/Detail Report as the link type.

   

2. Select the Browse button next to the Report text box to specify the report in the same catalog which contains the report tab you want for the detail report, and then select the report tab name from the Report Tab drop-down list.
3. Select the Browse button beside the Component text box. In the Choose Component dialog box, specify which data component in the detail report (detail data component) you want to interlink with the master report with conditions. You can select more than one detail data component as long as the data components are based on the same dataset.
4. From the Target drop-down list, select where to load the detail report.
5. In the Anchor section, specify the join relationship between the master report and detail report. The join can only have one condition. For example, the join can be: (Detail Report) Product ID = (Master Report) Product ID. The join condition should be as:

   (Detail Report) expression1 operator (Master Report) expresion2

   To make the join more meaningful, "expression1" should be a DBField or record level pass oneformula in the GROUP panel of the selected data component in the detail report; and "expression2" a DBField or record level pass one formula in the DETAIL panel of the data component that contains the trigger object in the master report. This is because generally the master report is used to present comprehensive data, and the detail report to present more detailed information. Therefore, based on this prerequisite, Designer only lists the qualified fields in the field drop-down lists of the Anchor section.

   To specify the join condition:

   1. Select a field from the Column in Detail Report drop-down list. If this list does not offer the required field, you need to select the detail data component the query used by which contains the specific field. To do this, specify the component by selecting the Browse button besides the Component text box again.
   2. Choose the operator from the Operator drop-down list.
   3. Specify the field of the master report from the Column in Master Report drop-down list. This field should be of the same data type as the selected detail report field.
6. Select the More button to display more options for setting the link.
7. In the Conditions tab, specify the filter conditions between the master report and the selected data components in the detail report. However, depending on where the trigger object is in the master report, you are not able to define filter conditions under some circumstances. For example, if the trigger object is a label in the report body, you can find that Designer does not enable the Add button .
   1. Select to add a condition line.
   2. Select the master report field from the Fields (Master Report) drop-down list. The provided field list contains the fields that satisfy the same conditions as for the Anchor section.

      When the trigger object is one of the following, Designer displays the item Current Field in the Fields (Master Report) drop-down list. Select it if you want to use the data field that is related to the trigger object in the filter condition.

      • A data field in a crosstab.
      • A DBField, formula field, summary field, or the special field Group Name in a banded object or table.
      • The chart legend which is bound with the category/series field of a chart, or the category/series axis of a chart.
   3. Choose an operator from the drop-down list in the OP column.
   4. Specify the detail report field from the drop-down list in the Fields (Detail Report) column. The available fields are those that satisfy the same conditions as for the Anchor section and at the same time are of the same data type as the selected master report field.

      When you select Current Field in the Fields (Master Report) drop-down list, if the dataset of the detail data component contains the data field which is of the same data type and the same name as the data field that is related to the trigger object in the master report, Designer displays the item Corresponding Fieldin the Fields (Detail Report) drop-down list. You can select it to use this corresponding field in the detail data component in the filter condition.

   5. You can specify more conditions by selecting and then specifying the master report field, the operator, and the field in the detail report. You can use the More column to specify the relationship between the conditions to be "AND" or "OR".

      To delete an unwanted condition, select it and select .

8. Designer enables the Parameters tab if there is at least one parameter applied in the filters of the queries that the detail report uses. In this tab, you can assign fields of the master report to parameters of the detail report to use the field values for the parameters automatically when running the detail report from the link.

   

9. If both reports use the same encoding and DB settings, you should select the option Use the same encoding and DB settings for the detail report as that of the master report. If you do not select this option, when the detail report is triggered at runtime, Logi Report prompts the report users to specify the encoding and DB settings for the detail report.
10. Select OK to confirm.

Then, when the report users run the master report at runtime, they can select the trigger object to open the detail report.

• The join and filter conditions work together. If you want to set a single condition, you can use join (anchor); if you want to set a group of conditions, you can use the filter conditions together with a join condition. The relationship between the join and filter conditions is "join condition AND (filter conditions)".
• When you specify the filter condition between the master report and detail report as Current Field = Corresponding Field, at runtime, Logi Report Engine ignores the condition if there isn't a matched corresponding field in the detail report, which means after the report users trigger the link, they get a detail report which is not filtered. In the meantime, Logi Report Engine adds an error message into log to record the issue.
• If you specify to load the detail report in a new browser window, at runtime, Logi Report Engine loads the detail report independently when the report users select the trigger, meaning Logi Report Engine does not apply the join and filter conditions you have set between the master report and detail report.

Linking to a URL

1. In the Insert Link dialog box, select URL as the link type.

   

2. In the Hyperlink text box, type the URL of the location to link with the object.
3. Select Add Dynamic Field if you want to insert a field into the URL to compose a dynamic URL. Designer displays the Select Field dialog box.

   

4. Select a field from the resource tree. You can select from all the data fields in the data resource that the data component containing the object uses. You should make sure the field you select contains the appropriate data to compose the URL.

   When the trigger object is one of the following, Designer displays the item Current Field in the resource tree. Select it if you want to use the data field that is related to the trigger object to compose the URL.

   • A data field in a crosstab.
   • A DBField, formula field, summary field, or the special field Group Name in a banded object or table.
   • The chart legend which is bound with the category/series field of a chart, or the category/series axis of a chart.

   For example, you can compose a URL as follows: type in http://www.google.com/search?q= into the Hyperlink text box, then select Add Dynamic Field to insert the field Country at the end of the URL. You can then select the trigger object to open a specific URL that directs to a specific country.

5. When the trigger object is in a crosstab, table, banded object, or table, Designer displays the All Available Values option. You can select it if you want to display in the URL all the runtime values of the selected field instead of only one value (you cannot select the option if the trigger object is an aggregate field in the crosstab). In the URL result, Logi Report Engine quotes each field value with a pair of single quotes and separates multiple values by a comma, and always applies the date format "yyyy-MM-dd" instead of the customized format to keep high data precision.

   When you select a field that is the same as the field related to the trigger object or as one of the trigger object's parent group fields, the value in the URL is always one value which is related to the value you select to open the URL.

6. Select OK to close the Select Field dialog box.
7. From the Target drop-down list, select where you want to load the URL.

   Logi Report Engine applies the specified target only when the report users trigger the link in Page Report Studio or Web Report Studio; when the report users trigger the link in JDashboard, except for Same Frame, Logi Report Engine treats all the other targets as New Window.

8. If the trigger object is in a web report table, Designer displays the IE Navigate2 Flags button. You can select it to use the IE Navigate2 flags to control the behavior of IE when loading the URL in Internet Explorer at runtime. You can select multiple flags at a time, while some of them may conflict with each other. The conflict relationship between the flags strictly follows the Microsoft MSDN specification. Logi Report Engine loyally delivers the user state to the Microsoft interface and does not present or check the conflict.

   When you link the object to a URL without selecting any of the Navigate2 flags, Logi Report Engine opens the location specified by the URL in the designated window if you provide a window name by selecting "Other Frame or Window" from the Target drop-down list; if you do not provide the window name, Logi Report Engine opens the location in a new window.

   To make sure the Navigate2 flags work well, you need to clear Enable Protected Mode in the Internet Options dialog box > Security tab of the Internet Explorer browser, then select the Custom level button and in the Security Settings dialog box, enable all ActiveX relative options under the ActiveX controls and plug-ins.

9. Select OK to set up the link.

Then, when the report users run the report at runtime, or view it in HTML, PDF, or Excel, they can select the trigger object to open the location specified by the URL.

Linking to an E-mail

1. In the Insert Link dialog box, select E-mail as the link type.

   

2. Type the e-mail address in the Hyperlink text box.
3. Select the Add Dynamic Field button to insert a field into the e-mail address using the Select Field dialog box if you want to compose a dynamic e-mail address.

   When the trigger object is one of the following, Designer displays the item Current Field in the resource tree in the Select Field dialog box. You can select it to use the data field that is related to the trigger object of the link to compose the e-mail address.

   • A data field in a crosstab.
   • A DBField, formula field, summary field, or the special field Group Name in a banded object or table.
   • The chart legend which is bound with the category/series field of a chart, or the category/series axis of a chart.
4. Select OK to set up the link.

Then, when the report users run the report at runtime, or view it in HTML, PDF, or Excel, they can select the trigger object to open the e-mail with the information that you specify here. They can further customize the e-mail and send it.

E-mail address syntax

When composing the e-mail address, you need to follow the syntax: sAddress[sHeaders]. See the details about the syntax below.

• sAddress
  One or more valid e-mail addresses separated by a semicolon. You must use Internet-safe characters, such as %20 for the space character.
• sHeaders
  Optional. One or more name-value pairs. The first pair should be prefixed by a "?" and any additional pairs should be prefixed by a "&". The name can be one of the following strings:
  • CC
    Addresses to include in the "cc" (carbon copy) section of the message.
  • BCC
    Addresses to include in the "bcc" (blind carbon copy) section of the message.
  • subject
    Text to appear in the subject line of the message.
  • body
    Text to appear in the body of the message.

Hyperlink examples:

• user@example.com
• user1@example.com;user2@example.com
• Customer Name@jinfonet.com, here "Customer Name" is a field name. Note that, fields can work in the hyperlink only when you insert them via the Add Dynamic Field option.
• salesmanager@Country.jinfonet.com, here Country is a field name.
• user@example.com?CC=user1@example.com&BCC=user2@example.com&subject=TestLinkToEmail&Body=Version%20x.x%0D%0A%0D%0ATest%20Link%20To%20E-mail

  Here is the e-mail result:

  

Linking to a Blob Data Type Field

When you link a report with Blob data type fields, Logi Report Engine binds the Blob data type fields to the trigger objects of the links and displays them as hyperlinks, the report users can then download the Blob content by selecting the hyperlinks in the report.

In Logi Report, Blob can be image, Binary, Blob, Clob, LongBlob, LongClob, Varbinary, Longvarbinary, and so on.

You cannot link page reports that use business views to Blob data type fields.

To make a report linked to a Blob data type field:

1. In the Insert Link dialog box, select Content as the link type.

   

   Depending on the location of the trigger object, you are not able to link the report with Blob data type fields under some special circumstances. For example, if the trigger object is a label in the report body, after you choose the Content link type, Designer displays a warning message and disables all the other options in the dialog box.

2. From the Query drop-down list, select the data resource which contains the required Blob data type field. The available data resources are those that come from the same data source connection as the data resource the current report uses.
3. From the Content Type drop-down list, specify the content type for the Blob type data. You can also select to bind the content type with a field in the selected data resource, or use a formula to control the type.
4. In the File Name text box, specify a file name for the linked Blob type data. You can also select to specify a field or formula to control the name.
5. From the Content drop-down list, choose a Blob data type field in the selected data resource.
6. Select the More button to display more link options.
7. In the Filter tab, specify the filter conditions between the data resource used by the current report and the data resource that contains the linked Blob content as follows:
   1. Select to add a condition line.
   2. Select the desired data field in the data resource that the current report uses from the Fields (Primary) drop-down list.

      When the trigger object is one of the following, Designer displays the item Current Field in the Fields (Primary) drop-down list. Select it if you want to use the data field that is related to the trigger object in the filter condition.

      • A data field in a crosstab.
      • A DBField, formula field, summary field, or the special field Group Name in a banded object or table.
      • The chart legend which is bound with the category/series field of a chart, or the category/series axis of a chart.
   3. Choose an operator from the drop-down list in the OP column.
   4. Select the linked field from the drop-down list in the Fields (Linked) column, which contains the data fields in the data resource containing the linked Blob content that are of the same data type as the selected field in the Fields (Primary) column.

      When you select Current Field in the Fields (Primary) drop-down list, if the data resource containing the linked Blob content has the data field which is of the same data type and the same name as the data field that is related to the trigger object, Designer displays the item Corresponding Field in the Fields (Linked) drop-down list. You can select it to use this corresponding field in the data resource of the Blob content in the filter condition.

   5. You can specify more conditions by selecting and then specifying the fields and operators accordingly. The relationship between these filter conditions is "AND", which means that Logi Report Engine fetches the linked Blob type data which meets all of the conditions.

      To delete an unwanted condition, select it and select .

8. Designer enables the Parameters tab if the data resource that contains the linked Blob content uses parameters. In this tab, you can assign fields of the data resource that the current report uses to the parameters to use the field values for the parameters automatically when accessing the Blob type data from the link.
9. Select OK to apply the settings.

Then, when the report users run the report at runtime, or view it in HTML, PDF, or Excel, they can select the trigger object to download the Blob content according to the specified conditions.

Editing the Links in a Report

You can edit the links added in a report at any time. To do this, right-click the trigger object of the link you want to edit and select Edit Link from the shortcut menu. In the Edit Link dialog box, redefine the link.

See also Edit Link Dialog Box for additional information about options in the dialog box.

Removing Links from a Report

To remove a link from a report, right-click the trigger object of the link and select Remove Link from the shortcut menu.

Example of Adding a Conditional Link

This example shows the usage of conditional link and dynamic field.

1. Make sure SampleReports.cat is the currently open catalog file. If not, select File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
2. Select File > New > Web Report to create a web report.
3. Insert a summary table in the web report which uses WorldWideSalesBV in Data Source 1 of the catalog, shows Product Name, Total Sales, and Total Cost, and uses the Basic style.
4. Right-click on the Product Name field in the second group header panel and select Link from the shortcut menu.

   

5. In the Insert Link dialog box, select the Conditional Link checkbox.
6. Select to define a condition in the Edit Conditions dialog box as follows:

   

7. We link the field to a URL target based on the condition. From the Link Type drop-down list, select URL. In the Message dialog box, select Yes.
8. In the Hyperlink text box, type in http://www.google.com/search?q= and then select the Add Dynamic Field button to insert the field Product Name at the end of the URL.

   

9. For the product names other than Blue Mountain and Breakfast Blend, we link them to an e-mail target. Select the Others checkbox and Designer creates a condition named "Others".
10. From the Link Type drop-down list, select E-mail. In the Message dialog box, select Yes.
11. In the Hyperlink text box, type in @example.com and then select the Add Dynamic Field button to insert the field Product Name right ahead of the "@" symbol.

    

12. Select OK in the Insert Link dialog box.
13. Select File > Save to save the report and select View > Preview As > Web Report Result to view the report result in Web Report Studio. We can select the product names in the table to trigger the link.
14. Select Blue Mountain and a Google search result page with the key text Blue Mountain displays.

    

15. Select Breakfast Blend and a Google search result page with the key text Breakfast Blend displays.
16. Select another product name other than Blue Mountain and Breakfast Blend to send an e-mail.

Previous Topic  Next Topic