I am using SSRS 2102 and trying to make a series of sales charts that first show regional data and then customer data from each region. I am finding that the same filter applied at the dataset level works differently than at the chart level
It looks like :
Region sum( transaction)
I have 2 charts... one to display sales data by region then another chart to display sales data by CustID
I use a Report Parameter (RegionParamter)to figure out the region for which the customer data is displayed
In order to only display customers within a specific region on my second chart I apply a region=RegionParameter filter on my CustID group in the second chart
Everything works fine if a customer only exists in 1 region however if a customer exists in 2 or more regions I only get customer data in one region... usually the last one in an ordered list.
However, if I apply the same region=RegionParameter filter at the dataset level the second chart works as expected... all customer data for each and every region is displayed... even if a customer is in multiple regions.
Has anyone experienced this and if so is there a workaround that you could share?