question

MariusBelean-5368 avatar image
0 Votes"
MariusBelean-5368 asked MariusBelean-5368 answered

SSRS Repeat tablix based on dataset

Hello,

I'm trying to achieve a repetitive tablix like in the picture below:
122389-screenshot-2021-08-11-at-201337.jpg


The thing is I want to generate multiple payslips in one report. E.g. if I execute the report for 6 employees, I need six repetitive tablix (for each employee) as in the picture above. The number of repetitive tablix depends on how many employees (rows from database stored procedure) I have.
How can I achieve this?
As I have inspected the report in Report Builder it looks like this:
122367-screenshot-2021-08-11-at-201407.jpg



I cannot find where to configurate to have this behaviour.
Any ideas?

Thank you,
Marius

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @MariusBelean-5368 ,
In view of your situation, I suggest you choose to use List.
For more information, please refer to: Create Invoices and Forms with Lists (Report Builder and SSRS).
Design:
122488-design.jpg
Preview:
122534-preview.jpg
Hope this helps.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



design.jpg (11.3 KiB)
preview.jpg (27.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MariusBelean-5368 avatar image
0 Votes"
MariusBelean-5368 answered

Hello @Joyzhao-MSFT
As you said, I have achieved this with the List few hours ago. I just came back here to write down the solution.
Thank you for your time and your solution!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.