is it possible to group fetched tabular data by a cell value that acts as a ID.
Column name may be ‘descriptor’ or ‘branch’.
Example data of rows:
I want to group them by the branch column and use that grouping in different tables.
One for giving a number of the count in each group, like:
Another table with summarize numb values for each group, like:
How is that possible?
Thanks in advance.
First of all you need to group by branch, then add a group footer and issue a
Count(1,true) there. The second parameter resets the count once it’s output. I prepared a simple sample for our demo application, here I’m grouping the employees by Country and add a correspondig group footer:
Next step is to suppress the data lines - this can be done in the line options:
The result then is as expected:
You can easily copy this table in the report container and use
Sum(...) instead of count to get a different statistic in the same report.
SimpleStatisticReport.srt (26.9 KB)