Dynamic Header in Data Analysis Mode

Version

Expected Effect

When there are detail columns and summary columns in the report, you want the report to initially display only the summary columns and display the detail columns after you click the button. The following figure shows the effect.

Implementation Method

Use the tree node to achieve the effect, and preview the report in the Data Analysis mode.

Note:

The effect can only be displayed in the Data Analysis Preview mode.

Data Preparation

1. Create a general report, and create a database query ds1 with the SQL statement SELECT * FROM Sales_Volume.

Report Design

1. Design the report cells as shown in the following figure. Set Expansion Direction of cells C1 and D1 to Horizontal, set Expansion Direction of cells A2 and B2 to Vertical, choose Summary > Sum in Data Setting of cell C2, and insert the formula sum(C2) in cell D2.

2. Set the left parent cell of cell C1 to cell D1.

Import Tree Node

Select cell D1, click Widget Setting, select Button Widget, and select Tree Node as Button Type, as shown in the following figure.

Effect Display

Save the report and click Pagination Preview. The effect is shown in section "Expected Effect."

Note:

The effect cannot be previewed on mobile terminals.

For details, you can click to download template Dynamic Header in Data Analysis Mode.cpt.