Listing Specified Data When Other Data Is Grouped

Version

Expected Effect

The grouping function is often used in report design, and all expanded data columns are grouped by default. How to realize that part of the data is grouped and part of the data is ungrouped?

For example, if the City column is empty, the data is shown in a list rather than in groups, as shown in the following figure.

 Implementation Method

The advanced grouping setting is used to transform specified data into different data through formulas, leaving some data ungrouped.

Report Design

1. Enter the SQL statement SELECT City,Gender,Full_name FROM Employe, to create a dataset, as shown in the following figure.

2. Design the report as shown in the following figure.

3. Select cell C2, and select Summary and Count for Data Setting, as shown in the following figure.

4. Select cell A2 and select Group and Advanced for Data Setting, as shown in the following figure.

5. Click Custom, select By Formula and Common Group, and set Custom Value to =if(len($$$)==0,seq()+"*",$$$), as shown in the following figure.

Note:

The formula seq() is used to generate different values, and adding a "*" is to make it easier to identify these processed values later.

Condition Attribute Setting

Select cell A2, and add a condition attribute to set New Value to null when the current value ends with '*', as shown in the following figure.

Effect Display

PC

Save the template and click Pagination Preview. The effect is the same as that shown in section "Expected Effect."

Mobile Terminal

The preview effects on the DataAnalyst app and the HTML5 terminal are the same, as shown in the following figure.

For details, you can download the template: Listing Specified Data When Other Data Is Grouped.cpt