Does anyone know how to do this?

I create a report and want to drill down to other reports or charts based on the value of my selection. For example, the drill down field A has values of 1,2,3,and 4. So if I right click 1 in my report, I want to drill down to another report B. If i right click value of 2 in my report, I want to drill down to report C instead of B.

Thanks
Jacky

This message has been edited. Last edited by: <Kathryn Henning>,

Diver,
Drill to report "Q" with the value clicked.
In Q, according to the value:
1 then EX B
2 then EX C

You can also use -INCLUDE instead of EX.

In the stylesheet, use the WHEN statement for the drilldown - something like:

TYPE=DATA, COLUMN=A, WHEN= A EQ '1',
  FOCEXEC=IBFS:/WFC/Repository/DomainFolder/ReportFolder/report_1.fex \
  PARM_A=A \
  ), $
TYPE=DATA, COLUMN=A, WHEN= A EQ '2',
  FOCEXEC=IBFS:/WFC/Repository/DomainFolder/ReportFolder/report_2.fex \
  PARM_A=A \
  ), $
...

Thank you Francis. It seems I am getting close. I change the stylesheet with when statement, it gives me the error say "Keyword has illegal value when= N2 EQ 'XXX' OR 'XXXX'. Any suggestion? Thanks

WHEN in the stylesheet works only with simple expressions like WHEN = A EQ 1, or WHEN = X LT 'ABC'. But is does not accept expressions with OR or AND.

So make an extra DEFINE:
TEST_N2/I1 = IF N2 EQ 'XXX' OR 'XXXX' THEN 1 ELSE 0;

and use WHEN = TEST_N2 EQ 1

Do not forget to add TEST_N2 NOPRINT to your TABLE request, otherwise the value is not known.

have you tried using the multi drilldown feature?

I like Danny's solution much better. "Simple, yet effective"

In fact the various drill-down reports can all be in the same fex if you use labels and a GOTO statement.

Now that you mention it, so do I.