How to split data of a single dataset in tablix in SSRS?

Mudit Dhebar 101 Reputation points
2023-11-20T23:19:12.8966667+00:00

Hi Team - I would like to split the data of a tablix into two from single table from one dataset. I am new to SSRS so any help will be appreciated.

Regards,
Mudit

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,860 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2023-11-21T01:31:16.9666667+00:00

    Hi @Mudit Dhebar

    How do you want to split the data into two? Should the split be placed in two tables, or in one table?

    If it is split into two tables, you can set conditions according to the filtering function. You can refer to this document: Add a filter to a paginated report.

    If it's in a table, maybe you can add groups, you can refer to this document: Grouping Data in the Report.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya