WorkWithPlus provides a mechanism to dynamically group columns at runtime. This feature is called Grouped Columns

The Challenge

The customer needs to group the Persons’s records by Gender, Country and Company. When the Person’s default list is loaded the records should be grouped by Gender, and then, the end-user can change the column. 

In the Person’s default list, define the "Group Type" property as follows:

Then, in PersonGender, CountryName and CompanyName attributes, define the following properties:

You should use the following caption:

format('%1: %2 (%3)', <ATT_DESCRIPTION>, <ATT_VALUE_DSC>,'<GROUP_COUNT>')

Then, set the PersonGender as the Default Group: 

Finally, hide the CountryId and CompanyId columns, and set the Group Field of CountryName and CompanyName to use CountryId and CompanyId, so the query is optimized:

Run the application and visualize the results at runtime:

Summary

Well done! You should now be able to:

• Define columns that will be used to group a grid
• Define the default grouping column