If I have a line graph (chart) with 3 measures going across -- basically 3 lines -- by time frame (categories at bottom), how can I tell which measure (which line) was selected? How can I see the value that was passed to the value prompt?
Put a text item on your report and change the source to report expression. Then make the expression point to a parameter (3rd tab).
Well, my problem is that my chart is calling a drill-through report with a crosstab on it. I've tried adding many text items to the Parent chart report as you suggest but they will not display because the dang thing opens the drill-thru after they select a hotspot on the chart and never fills in the text boxes. If I disable the drill-thru I won't be able to see what they selected in the chart, will I? The hotspots will be deactivated?
Put the text items on the drill through - That way you can see what has been passed to it.
Hi Calson33,
The text item on the Target (crosstab) report is coming up blank--or I'm being prompted for a value--that's why I want to know to know what value is actually being passed! ;)
Can you think of another way to see it? I basically am getting all but the dang name/caption of the Measure that is being selected in the chart.
It looks like I get the number/measure value instead of the measure name so I changed the paramter in drill-thru defs to pass the Member Caption instead of the Data Value but it keeps passing a number as far as I can tell. Could there be some cache that I can clear?
Thanks for all the help!
I am afraid I don't have any other ideas :-\
Maybe redo your drill through definition to see if that is the problem?