How to create layout with multiple tablix (like Power BI) in SSRS?

Question

How to create layout with multiple tablix (like Power BI) in SSRS?

Trushit Vaishnav 41

I have following report in Power BI as show in the screenshot below. I want to replicate the same layout in SSRS. Power BI allows users to select data for just one set of slicer at a time. For instance, power bi report will show data for given month and project. I need an ability to run the report for multiple projects. So if user selects 5 project, the similar layout for 5 projects should be generated when SSRS report in run , each on its own page.

Each table comes from different dataset. I am able to create table located right below the slicers in the required way. But I am unable to add tables located at bottom left and chart to the same tablix or even on the same page.

I could achieve the desired result using sub reports but that is too slow. So that is not a acceptable solution. Query that supports the report is complicated and in sub report approach, this query will have to run for each job making it extremely slow.

Any help is truly appreciated.

1 answer

Your answer

Answer 1

Joyzhao-MSFT 15,636

Hi @Trushit Vaishnav ,
Using multiple datasets in one data region is supported in SSRS, which means you can create multiple tablixes from different datasets in one report at the same time. But a Tablix can only come from one dataset.

For the filtering of [Month] and [Project], if you need to select multiple projects, you can use Multi-value parameters to filter the three tables. The premise is that all three datasets have @Month and @Shayna Webb as parameters.

For Tablix's pagination, you can insert report page breaks.

In order to repeat the chart on each page, you can create a List, and then insert the chart in the List.

Best Regards,
Joy

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Trushit Vaishnav 41 Reputation points

2022-09-16T15:18:15.9+00:00

Hello @Joyzhao-MSFT ,

Thank you for taking out the time to respond. I tried the approach you suggested and came up with the following layout:

Both these tables use different datasets. When I run the report, I see upper tablix results for all the jobs and then I see second tablix for all the jobs.

I want to show first and second tablix for first job , then do the same for second, third and all the jobs selected. How do I do that? I think page break should help but I am not able to figure it out. Can you help?

I know I can do this by creating a main report and adding three tablix as subreport but that is too slow. I am looking for a way where dateset query does not have to run multiple times.

Share via

How to create layout with multiple tablix (like Power BI) in SSRS?

1 answer

Your answer