In Scriptcase, you can quickly group queries. You can create this rule type in the grid type applications, in a few clicks you will have a full report with this functionality.
To configure this feature go to the properties of the application, then select the “Group By”. Inside there is the option “Group By Rules” where you can create them and edit them.
On the screen that opens you should enter the most basic information such as name and label of the rule and also which of the fields will be used for grouping.
Once finished creating the rule you can edit it by selecting it and editing the fields, in addition, can also implement custom events using the folder “Events”. Notice in the picture below that all items have a didactic description that tells exactly what functionality of the item.
This format is much easier to create and define grouping formats, test this functionality that guarantees for you time and results in their applications.