Repeat entire table in RDLC report

1
votes

Currently in my report showing data in single table.

enter image description here

But right now I need to split this table in to multiple tables based on department like this :

enter image description here

enter image description here

How I can achieve this in rdlc. I am new in rdlc report.

1
reporting-servicesrdlc

1 Answers

0
votes

Normally you dont add for each Department a tablix, you just use one tablix and group it by the Department. Go to the bottom of you report design under RowGroups. Click on the (Details) drop down arrow and select Add Group > Parent Group and select your Department. You even can add totals under each grouped department.

If you really want more tablixes you copy paste the same tablix a few times and then add a filter. Tablix Properties > Filters > Add, then add your Department filter.