two tablix each with it's own dataset in same report

Question

I am trying to display two tablix using separate datasets in a single report.  Can someone explain how to do this as my method is not working.

Thanks

Answer 1

Hello,

What's not working on your method? You just have to add a second dataset and use it for the second tablix.

---

Olaf Helper
Blog Xing

Answer 2

Hello

thanks for your response.

I am using an SSRS Model.  Both datasets are using the same model but with different filters.  As an example,

dataset A brings back the sum of all sales in a particular region and grouped by Month in Tablix 1.  Dataset B brings back all sales in another region also grouped by month in Tablix 2.     Tablix1 on it's own  returns the correct figure but when I include Tablix 2, it seems that the sum of dataset A is added to Dataset B.

thanks

Answer 3

Hi Rickytoe,

According to your description, I have tested the issue in my test environment, however, everything goes well. Please make sure you have added the filter correctly when creating the dataset B.

To work around the issue, I suggest that you create only one dataset without filtering the region data. Then, you can add a filter to each Tablix or to the target group in each Tablix separately to filter the region field.

Reference:
How to: Add a Filter

Regards,
Mike Yin

---

Mike Yin

TechNet Community Support