I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening?
The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this:
Years
Counties Total Crashes Fatalities
Cook 85 98
Manchester 2850 258
Sagamon 987 526
So when a user clicks a county, such as "Cook", this is displayed
Years
Age Gender Total Crashes Fatalities
0-8 Female 25 8
Male 55 15
9-15 Female 850 258
Male 185 35
16-22 Female 87 526
Male 10 35
But I am getting this in :
Years
Age Gender Total Crashes Fatalities
0-8 Female
Male
9-15 Female
Male
16-22 Female
Male
Whats going on? Can anyone make any suggestions? Just to let you know its based off of an Analysis Services Cube and not relational tables.
Does you second report have a county parameter? and, if so, have you linked the County field in the first report to the parameter in the second report?
- Ali
|||Yes, my second report has a county report paramater, and i did the hyperlink the first report parameter to the second. (Right clicked county>Properties>Navigation>Jump to Report>Parameters>CrashCounty=Fields!CrashCounty.value).
It seemed to be linking, but its not displaying hardly any values. I have this report seperate with out the linking and its filled with values. Did i forget something?
No comments:
Post a Comment