SSRS Repeat tablix based on dataset

Marius Belean 21 Reputation points
2021-08-11T17:23:05.363+00:00

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
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,878 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-08-12T03:21:11.063+00:00

    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).
    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Marius Belean 21 Reputation points
    2021-08-12T15:12:59.81+00:00

    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