How can I group 'vertically' at multiple levels in RDLC reports?

Question

I'm trying to write a report using RDLC with Visual Studio 2022 Community Edition.

All my data is 'flattened' to a single row per item like this:

Date	Type	Description
Jan 1	First	This, that and the other
Jan 1	First	More of the same
Jan 2	First	Something about the second of Jan
Jan 2	Second	And now a different type
Jan 2	Second	And something else that belongs to this second type

And I would like to group down the page, rather in across in columns, on Date, and then on Type:

Jan 1
First
This, that and the other
More of the same

Jan 2
First
Something about the second of Jan

Second
And now a different type
And something else that belongs to this second type

I can get an indented layout using row groups, but column groups, which SEEM to work down the page, do not produce an equivalent result as far as I can see.

Can anyone point me in the right direction.

A recommendation for a good, useful guide to RDLC reports would also be appreciated!

I've tried both tables and lists as report items, and just about every combination of row and column groups, adjacent groups.

Answer 1

Have you try do this?

1. Create Table

2. Make the Detail Group on Row to Description i use subcategory

3. Create Parent Group of Description with group header, for Type i use category

4. Create Parent Group of Type with group header for Date i use source [

5. Move the value to the last column

6. Remove every volumn except the last column and the top row