How to apply grouping in SSRS RDL report

1
votes

I have to create report SSRS RDL.I am new to report.

Can anybody suggest me how to design report OR apply grouping so that it looks alike as given below format:

enter image description here

and following records are coming from database:

enter image description here

Where

Total AA = 3(1+2),4(3+1)

Total A = 8(3+5),5(4+1)

Thanks

1
reporting-servicesssrs-grouping

1 Answers

1
votes

Either right click the cell and select Add Group and then Parent Group under Row Group or right click your details group under Row Groups window.

EDIT:

Attached some images showing the process:

enter image description here

Then you select the field used to group and if you want to add a header/footer.

enter image description here

For your total you can use [Sum(FieldName)].

It will sum only the data inside that group.