I. Description
The grouping function is often used when designing reports. The default grouping is that the entire expanded data column is grouped. How to achieve partial data grouping, and some data not grouping?
As follows, when the city is empty, then list display instead grouping.
II. Idea
Use the advanced grouping attribute to transform the specified data into different data through formulas to achieve the purpose of not grouping.
III. Resolution steps
1) Create a dataset: SELECT City,Gender,Full_name FROM Employe
2) The report design is as follows:
Among them, drag Full_name to C2, and the data is set to Summary>Count:
3)Select cell A2, set the data to Group>Advanced, click Custom, select Formula Group>Ordinary Grouping, and then custom value: if(len($$$)==0,seq()+"*",$$$)
Note: The seq() formula is used to generate different values, and the * is spliced to make it easier to find the processed value later.
4) Select cell A2, set the Conditional Formatting, when the current value ends with *, the new value is empty
IV. Effect preview
Save the template, click Pagination Preview, the effect is shown in I.Description.
Note: Support mobile preview, both App and H5 are supported.
V. Completed template
Refer to the completed template: %FR_HOME%\webroot\webapps\WEB-INF\reportlets\doc-EN\ReportApplication\BasicApplication\Specified_display_under_ grouping.cpt
Click to download:
Specified_display_under_grouping.cpt