Trouble adding Groups to a Report with a Table

[Kevin]

I have a report that has a table that is populated from a stored procedure showing sales by contract - one line per contract.

I need to add 2 levels of groups so that I can show Sales by Salesperson within Shop with a page break on Shop and totals at both the Salesperson and Shop levels.

I have tried adding 2 Groups and moved the table to the last Group Header section but the grouping doesn't seem to be doing anything.  The report is not showing any Shop or Salesman details.  The design is shown in the attached image.

 

What am I missing?

Regards

Kevin

 

[Todor]

Hello Kevin,

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.

Regards,
Todor
Progress Telerik

[Kevin]

Hi Todor

Thanks for your reply. 

I have added 2 Groups under the Report properties, one for Fields.Shopname and one for Fields.SalespersonName, but am not sure how to link the GroupHeaderSections to SalespersonName and Shopname.  Is this using Bindings?

When I run the report I don't have any Shop or Salesperson details displaying.  I added a text box in each GroupHeaderSection e.g. for ShopName the field is "= First(Fields.ShopName)".  I also placed the table in the SalespersonName's GroupHeaderSection.

What am I missing?

I wasn't sure how to open the example you supplied.

Regards

Kevin

 

[Todor]

Hi Kevin,

The example can be opened with the Standalone Report Designer.
You can also convert it to a .cs report as explained here, and open it with the Visual Studio Report Designer.

If you need further help, I suggest you to open a support ticket where you would be able to attach your report.
After investigating the report locally we might come up with more specific advices.

Regards,
Todor
Progress Telerik