Nested Grouping

[Johnny]

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.

[Gimmik]

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?

[Accounts]

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.

[Stef]

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

[venkateswararao]

i have 4 groups in my report 1 group is working fine according to grouping and 2 Group  is combination of 1 and 2 groups and 3Group is combination of 1 and 2 and 3 and 4 group is combination of 1 and 2 and 3 and 4groups.

how can i do individual grouping in telerik report?

first image working fine same way i need but second and third images combining