SSRS Grouping with multiple columns

Question

I have a SQL table called 'Voucher'

The resulting report must look like this:

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?

Answer 1

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

How did I achieved this?

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

Here is grouping details for you.