I've a requirement where I need to design a dashboard with 6 pie charts. Each pie chart will have drill down / drill through capabilities.
All charts have same series meaning, Chart-1 is TotalSales vs Region, Chart-2 is Profit vs Region and so on.
I need to have a single table displaying legends (Region in this case). I'll build expressions to have uniform color for a region across all 6 charts.
Restriction is: I'm not supposed to create any new objects (table, stored procedure) in database. All the logic/ code is handled in report.
Now to have color defined against each region, what options I would have?
I had thought of Shared Dataset but Shared Dataset is not supported in SSRS 2005.
Using a dataset within a dataset is also not feasible, as far as I've explored.
At present, I've an option of creating a temp table to hold region & color. Then join this table with main query. But for 6 charts, I'll have to repeat it 6 times. In case I need to change color for a region, it would be prone to mistakes.
Do I have any other options?