I`m working on some reports with SSRS 2008. My database are OLAP-Cubes. The situation:
The first tablix shows the number of new cases, sorted by region and - in a seperate row - the total over all regions (region as overgroup, and subregions as subgroup).
The second tablix shows the number of settled cases, again sorted by region and the total over all regions.
The third tablix should display the percentage of settled cases based on the number of new cases.
I can manage that for the total over all regions, but if I use the same formula for the regions I can´t get SSRS to show the correct value. All I get is exactly the same figure, I already have for the total over all regions and I know that can´t
Is there anyone who could tell me how to get the figures for the regions?
I tried to use the datasets for the tablixes of new and settled cases, but if I want to use fields of datasets which are not the special dataset for the tablix, I only can get the "sum(Fields.xy.value)" and not the "Fields.xy.value" which
I need. I tried to generate a "calculated expression but I am completely new to MDX so - no surprise - that doesn´t work either.
Your help would be much appreciated!
View Complete Post