Row Based Drill-Throu Reports in Report Author 10.2.1

[gosoccer]

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.

[ww55d]

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

[gosoccer]

OK, Thanks so much. I'll review the document. Have a great evening.