Hi everyone, :)
I have a requirement for running different Reports as Drill-through but based on each row of the Crosstab. So, if the value of the first row is showing value A in the first column, Report A needs to be the Target Drill-through Report. If the value of row A changes to B, Report B needs to be the Drill-through Target Report.
Please let if you can.
Thank you so much for your time.
This is possible however it gets a bit messy --
rather than a drill-through, you could have those values become HTML fields that create a link passing to different locations.
To specify report A or B, there would have to also be a CASE statement involved like:
when field1 = B then http://######/##..b
else http://###/##..a
This has more detail on passing prompt parameters through a URL.
http://www-01.ibm.com/support/docview.wss?uid=swg21338766
OK, Thanks so much. I'll review the document. Have a great evening.