SSRS Repeat tablix based on dataset

Marius Belean 21 Reputation points


I'm trying to achieve a repetitive tablix like in the picture below:

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:

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

Thank you,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,831 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points

    Hi @Marius Belean ,
    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).
    Hope this helps.
    Best Regards,

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Marius Belean 21 Reputation points

    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!

    0 comments No comments