Hi all,
I need to create a report that has alternate drill throughs based on the intersection of a report chosen. For example, if someone clicks on a value for the intersection of "tissues" and "ytd sales", then a drill though report for sales by channel is run, whilst if they click on a value intersecting "cups" and "ytd sales", a drill through report for sales by vendor is run. Both drill through reports are fundamentally different (sorry about the examples, but they were sitting on my desk!) and the rows in the report (tissues or cups in my example) are data driven and there are only two possible elements.
Does anyone have any ideas how to do this?
Thanks
John
With just two possibilities... I would set up the target report with two data containers. Set up a render variable to inspect the passed data item, and use that to control which data container to show.
Wow. Thanks bdbits! Any tips on how I would setup the render variable and how I would then use that to control the drill target? Thanks again for your help. John
Assume the parameter you are passing is named 'pProduct'. Create two render variables.
Expression for variable rTissues: ParamValue('pProduct') = 'Tissues'
Expression for variable rCups: ParamValue('pProduct') = 'Cups'
Now on the properties for the data container for tissues, set the render variable property and choose the rTissues variable.
Same for Cups, but set the render variable property to the rCups variable.