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