CODEWITHSUNDEEP
asp.netrdlcssrs-tablix
SHAKIR SHABBIR
SHAKIR SHABBIR

Reputation: 1295

How do I group header and details in a RDLC report

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: enter image description here

Upvotes: 0

Views: 10895

Answers (1)

SHAKIR SHABBIR
SHAKIR SHABBIR

Reputation: 1295

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.

Upvotes: 2

Related Questions