An easy way to achieve the requirement is to add two Report Groups (check grouping data
) - the outer one grouping over Shop, the inner - over Salesperson.
To have each shop on a different page I suggest setting the Shop group GroupFooterSection PageBreak
property to 'After' - after each shop group the report will continue to render on the next page.
The name of the Shop could be displayed in the Shop GroupHeaderSection, and the name of the Salesperson - in the Salesperson GroupHeaderSection (will be displayed once per group).
The Totals could be displayed in the corresponding GroupFooterSections - use Sum aggregate function.
The detail data could be displayed directly in the detail section (i.e. without Table), since the grouping is already done with the introduced Report Groups.
I have attached a sample report demonstrating the approach. It uses inline CsvDataSource. The Groups are colored to be easily distinguished from one another.
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items