Nested Grouping

4 posts, 0 answers
  1. Johnny
    Johnny avatar
    1 posts
    Member since:
    May 2013

    Posted 23 May 2013 Link to this post

    I have 5 groups in my report (say Group 1, Group 2, Group 3, Group 4, Group 5)
    Group 1 - parent, Group 2 - child of Group 1, Group 3 - child of Group 2, Group 4 - child of Group 3 and Group 5 - child of Group 4

    Group 4 and Group 5 are by default true but Group 1, 2 & 3 depends on the parameter (with multivalue/checkboxes - Group 1, 2 ,3)
    i.e. user can choose combination of Group 1,2,3 or null

    How can I set it up in the Telerik Report Designer?

    Something like this--

    Group1 - depends on parameter value
    Group2 - depends on parameter value
    Group3 - depends on parameter value
    Group4 - always true
    Group5 - always true
    Data:- Name, Amount
    Data:-Total by Group4  Sum(Amount)

    It should always show the Data no matter what combination of parameters user choose or null.
  2. Gimmik
    Gimmik avatar
    170 posts
    Member since:
    May 2011

    Posted 23 May 2013 Link to this post

    Hi Johnny,

    You effectively have the right idea. You'll need to have valid (selected or default) values for both parameters before rendering the report. All the data selected by the data source with fields in the detail section will be displayed exactly once. All the data is first grouped based on the grouping expression you set in Group1, say by Category (Pants, Shirts, Shoes). Then - within those groups, the data is then grouped again based on the expression in Group2, say by Color (Red, Green, White) and finally grouped again my Group3 (striped Solid). Your data would be be displayed like this:

    Pants
    --Red
    ----Striped
        (All Striped Red Pants)
    ----Solid
        (All Solid Red Pants>
    --Green
    ----Striped
        (All Striped Green Pants)
    ----Solid
        (All Solid Green Pants)
    --White

    ...
    ...

    Shoes
    --White
    ----Solid
        (All Solid White Shoes)

    Does that makes sense?
  3. Accounts
    Accounts avatar
    1 posts
    Member since:
    Jan 2014

    Posted 26 Jan in reply to Gimmik Link to this post

    is there way to have the "nested" sub-totals too? When I added 2 groupings, it is acting as a single grouping by group-1, group-2, effectively one group based on 2 data-fields. I want 

    Group-1 : header

        sub-group-1: header

           data rows

        sub-group-1 (sub)totals

        sub-group-2: header

          data rows

       sub-group-2 (sub)totals 

    Group-1 sub(totals) 

    Group-2 ...and so on.

    if I add 2 groups, they become 2 non-nested sibling groups.

    Can someone elaborate how nested subgroups are done?

    Thanks.

  4. Stef
    Admin
    Stef avatar
    3413 posts

    Posted 27 Jan Link to this post

    Hi,

    Please check the attached video in IE browser.
    The layout is created through the Band Report Wizard.
    If you use a Table item, row groups can be added through the Group Explorer allowing you to specify if you want a parent, adjacent or child row group - the result will be similar to Product Sales demo (available in the local examples as well).

    For more details, check Grouping Data.

    Regards,
    Stef
    Telerik by Progress
    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