Saturday, September 08, 2012 9:08 PM
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.
Sunday, September 09, 2012 6:37 AM
Sunday, September 09, 2012 4:03 PM
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.
Saturday, September 15, 2012 6:21 PMModerator
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.
How to: Add a Filter
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Thursday, September 20, 2012 5:08 PM