Trouble adding Groups to a Report with a Table

4 posts, 0 answers
  1. Kevin
    Kevin avatar
    2 posts
    Member since:
    Dec 2012

    Posted 05 Mar Link to this post

    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

     

  2. Todor
    Admin
    Todor avatar
    145 posts

    Posted 08 Mar Link to this post

    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
    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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Kevin
    Kevin avatar
    2 posts
    Member since:
    Dec 2012

    Posted 12 Mar in reply to Todor Link to this post

    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

     

  4. Todor
    Admin
    Todor avatar
    145 posts

    Posted 14 Mar Link to this post

    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
    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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top