Dynamic Multi-Sheet Display by Drop-down Checkbox

Version

Application Scenario

You may want to select and preview the required report conveniently, as shown in the following figure.

Implementation Method

1. Sub-template: You can modify the sheet name and the template name for later use.

2. Main template: You can prepare the data, bind the template parameter to the drop-down checkbox widget, and pass the template URL to the iframe widget in the report by the drop-down checkbox widget. The iframe widget displays the preview effect of the template. If multiple templates are selected, the templates will be displayed in multiple sheets.

Sub-template Preparation

1. Open the template Group_Summary.cpt in %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Primary\GroupReport.

2. Right-click sheet1 in the lower left corner, select Rename, rename the sheet Sales Volume by Salesperson, and also rename the file Sales Volume by Salesperson, as shown in the following figure.

3. Open the template LineForm1.cpt in %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc\Form\LineForm.

4. Right-click sheet1 in the lower left corner, select Rename, rename the sheet Product Details, and also rename the file Product Details, as shown in the following figure.

Template Creation

Create a general report, as shown in the following figure.

Data Preparation

1. Encode the template path:

The path of Sales Volume by Salesperson is %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Primary\GroupReport\Sales Volume by Salesperson.cpt.

You only need to encode {reportlet:'/doc-EN/Primary/GroupReport/Sales Volume by Salesperson.cpt'} . The encoding result is %7Breportlet%3A'%2Fdoc-EN%2FPrimary%2FGroupReport%2FSales%20Volume%20by%20Salesperson.cpt'%7D%20.

The path of Product Deatils is %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Form\LineForm\Product Deatails.cpt.

You only need to encode {reportlet:'/doc-EN/Form/LineForm/Product Sales.cpt'} . The encoding result is %7Breportlet%3A'%2Fdoc-EN%2FForm%2FLineForm%2FProduct%20Sales.cpt'%7D%20.

Note:

The paths within the square brackets are used for encoding.

2. Create a built-in dataset Report list and store the paths (obtained by encoding) of sub-templates, as shown in the following figure.

Template Parameter Adding

Choose Template > Template Parameter, click +, and set the parameter name to report, as shown in the following figure.

Parameter Binding to the Widget

1. Enter the editing page of the parameter panel, and click Add All to add the parameter to the parameter panel, as shown in the following figure.

2. Bind the parameter to the drop-down checkbox widget, as shown in the following figure.

3. Set Type to Data Query in Data Dictionary for the drop-down checkbox widget, as shown in the following figure.

Iframe Setting

1. Merge a range of cells, click Widget Setting, and select Iframe from the drop-down list.

2. Set the address to ${servletURL}?reportlets=%5B${report}%5D&op=view, as shown in the following figure.

Note:

${report} is the report path passed over by the parameter report, and op=view specifies that the report preview mode is Data Analysis Preview.

Effect Display

Note:

The effect cannot be previewed on mobile terminals.

Save the template, and click Data Analysis Preview. The following figure shows the effect on PC.

For details, you can download the sub-template Group_Summary.cpt.

For details, you can download the sub-template LineForm1.cpt.

For details, you can download the main template Dynamic Multi-Sheet Display by Drop-down Checkbox.cpt.