Pass Column Header via Drill Through

[dodger]

Hi Folks

I have a cross tab with measures "Total Value", "Total Units" and "Price" and the user has the option to drill through to a detail report.

My target has all 3 of the above measures and I only want the one which the user drills through on to be visible, so I set up a hidden text box on target and will pass over the column header to the hideen box on the target. I will finally conditionally format the target based on the hidden value to show the appropriate measure.

My question is to do with passing the header over. I have tried every property in the drill through definitions but its still passing over the actual numeric value of "Total Value" rather than the column header "Total Value". I thought was member caption but tried all and they all pass over a numeric value.

Any held would be greatly appreciated.

Jamie