reporting-servicesssrs-grouping

SSRS Grouping with multiple columns

I have a SQL table called 'Voucher'

enter image description here

The resulting report must look like this:

enter image description here

Design Considerations: Report must Group by Name, then group by VoucherType and be sorted by Date

Please can someone help me with steps on how to do this?

Solution

  • In below Image left hand side is original table and right hand side is your desired result,

    enter image description here

    How did I achieved this?

    First Parent Group by Name and then Child group by Vourcher Type

    enter image description here

    Here is grouping details for you.

    enter image description here