Grouped by Condition

1. Expected effect

The previous section introduced Grouped by Section . If you want to group some specific values into one group for data display, for example, the main areas of general enterprises are North China and South China. The south is the main viewing object, while other regions are aggregated in the "Other" group, which is merged grouping, as shown in the following figure:

2. Implementation ideas

You can use the grouping in the data column properties to customize the grouping settings.

The steps of making the template are described below.

1. Report design

1) new report

Create a new general report, add data set DS1, and the SQL statement is select * from sale, as shown in the figure below:

2) report style

Drag the field to the corresponding cell to list the data of all regions. The report style is as follows:

2. Group setting

Select the A2 cell where city is located, and modify the data settings to group and advanced. As shown in the figure below:

Click the custom button in the figure above to pop up the custom grouping dialog box. Select the conditional grouping to merge the cities into two groups. As shown in the figure below:

Group 1: named North, set the city Beijing to North.

Group 2: named South, set the city Shanghai to South.

For the cities not grouped, you can choose to merge all the other groups from the drop-down box as above. 

3. Effect preview

1) PC terminal

Save the template and select pagination preview, as shown below.

2) Mobile terminal

The App  has the same effect as the HTML5 side, as shown in the following figure:

For completed templates, please refer to:

%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportApplication\BasicApplication\

GroupInCon.cpt

Click to download the template:

GroupInCon.cpt