This is a migrated thread and some comments may be shown as answers.

Nested Grouping

4 Answers 333 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Johnny
Top achievements
Rank 1
Johnny asked on 23 May 2013, 05:55 PM
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.

4 Answers, 1 is accepted

Sort by
0
Gimmik
Top achievements
Rank 1
answered on 23 May 2013, 09:40 PM
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?
0
Accounts
Top achievements
Rank 1
answered on 26 Jan 2017, 10:01 PM

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.

0
Stef
Telerik team
answered on 27 Jan 2017, 04:59 PM
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
0
venkateswararao
Top achievements
Rank 1
answered on 30 Jun 2018, 02:01 PM

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

Tags
General Discussions
Asked by
Johnny
Top achievements
Rank 1
Answers by
Gimmik
Top achievements
Rank 1
Accounts
Top achievements
Rank 1
Stef
Telerik team
venkateswararao
Top achievements
Rank 1
Share this question
or