Web Report

1) Web reports are hyperlinks designed for jumping between reports.

2) Jumping between reports can be realized through JavaScript. Web reports provide a setting interface that enables report developers having no JavaScript knowledge to quickly realize the effect of jumping from one report to another.

3) This article introduces two methods of setting a web report, which can realize the effect of jumping to GettingStartedEN.cpt.

4) You may refer to Basic Settings of Hyperlinks.

1. Insert a dataset

1) Create a new DB Query dataset [ds1].

2) Use the following SQL statement to extract all values of [Region].

SELECT DISTINCT Region FROM Sales_Volume

3) Preview the dataset

Values of [Region] include East China and North China.

2. Design a report

Drag [region] in [ds1] into B2.

3. Insert a web report

1) Click B2, insert a hyperlink in the right-hand pane, and select [Web report] as the type.

2) The [Web Report] setting interface pops up.

4. Set the target report to jump to

Click Select and select GettingStartedEN.cpt in the pop-up window as the target report to jump to.

5. Set the way to open the page when jumping to a new report

1) After clicking the drop-down box, you can see three options: New Window, Dialogue Box and Current Window.

2) Select New Window by default.

Note:After reading this section, you may at your option change the way to open the target report, and view the effect.

6. Set the parameter transfer mode

1) After clicking the drop-down box, you can see two options: GET and POST.

2) Select GET by default.

Note1:Please select the parameter transfer mode actually needed:

Note2:If many parameters are to be transferred or for security reasons, please select the POST mode.

Note3:If just a few parameters are to be selected and these parameters have no significant impact on the report system, the GET mode, which is the default option, can be selected.

7. Set whether or not to display the parameter pane of the target report

Unchecked Display Parameter Pane.

8. Set the parameter to be transferred

1) Click + to add the parameter to be transferred to the target report.

2) Set the parameter name as region (note: the target report contains a parameter named region).

3) Set the type of the parameter value as [Formula] and input $$$ in the pop-up formula definition box, which means transferring the current cell value to the target report as the value of the parameter region.

9. Preview

1) Two hyperlinks, namely East China and North China, appear in the report.

2) A new window appears when clicking either of the hyperlinks. The content of the new window is consistent with the report body in GettingStartedEN.cpt, but no parameter pane is displayed. Sales data in East China and North China is directly displayed.

3) The figure below displays the process of previewing GettingStartedEN.cpt, which indicates that the effect of a parameter pane is realized directly through the setting of the Web report, i.e., controlling the content of the target report through hyperlinks.

10. Modify the setting into displaying the parameter pane of the target report

Checked Display Parameter Pane.

11. Preview

1) Click the two hyperlinks: East China and North China respectively. A new window appears. The content of the new window is consistent with the preview effect of GettingStartedEN.cpt, but the default values of Region are East China and North China respectively.

2) Such Web report setting controls the default values of parameters in the target report.

1. Design the report

Input View Sales Report in B5.

2. Insert a hyperlink and set the web report

1) Insert a [Web Report] into B5.

2) Select GettingStartedEN.cpt as the target report, and maintain the default values of other settings, with no parameters transferred.

3. Preview

1) A hyperlink named View Sales Report appears on the page.

2) By clicking the hyperlink, the new window displays the content of GettingStartedEN.cpt.

3) Super hyperlink setting enables adding an access on the page to another report.

Note:Web reports can only enable jumping between two reports in a report project. If the target report is located in a cross-domain report project, jumping to the target report should be realized through [Webpage Link] or [JavaScript].