How do I group header and details in a RDLC report

Question

I am trying to do the following in an RDLC Report:

I have a table:

ChequeTmp

[ChequeNum], [ChequeDate], [ChequeAmount], [Invoice], [InvoiceDate], [InvoiceAmount]

There can be multiple cheques in the the ChequeTmp table and for each cheque there can be 0 or many stub lines.

How do I display this data on an RDLC report? Note: I have to first display cheque info followed by its stub details and then another cheque followed by its respective stub details

PS: I am trying to achieve the following design:

Answer 1

Solution:

1. Place the header data and details data in a single table.

2. Add a Table to RDLC Report and set its data set to that single table.

3. Add a group: ADJACENT ABOVE

4. Delete the details row group.

5. Add a row in the adjacent group.

6. Merge cells in the first row and put all your header details here in a rectangle.

7. Create another table outside of the first table and assign your details to it.

8. Drag and drop that table to the first table adjacent row.