Friday, February 17, 2012

Drillthrough (beginner)

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