Dear Sir,

We can use condition to control a special value cannot drill down, but when we want to control more values, we cannot found how to do it. Are there any one have the experience. Your responses are appricate. Thank you

Best Regards,
B. H. Tang

Tang :
Please explain the kinds of conditions in more detail if you could. That will help you get specific answers.

If you are talking about supressing drilldown on various conditions, here are couple of ways that we do it -
1>> Bypass the drilldown statement in the stylesheet by using DM statements

ON TABLE SET STYLE *
-IF &VAR1 EQ 'X' GOTO LBL_SKPDRLL;
-IF &VAR2 EQ 'Y' GOTO LBL_SKPDRLL;
TYPE=DATA,OBJECT=FIELD,ITEM=1,FOCEXEC=......
-LBL_SKPDRLL
ENDSTYLE

2>> Or you can dynamically comment out Drilldown statements by assigning '-*' to the front like this..

-SET &COM1=IF (&VAR1 EQ 'X') OR (&VAR2 = 'Y')
- THEN '-*' ELSE ' ' ;
-*
ON TABLE SET STYLE *
&COM1.EVAL TYPE=DATA,OBJECT=FIELD,ITEM=1,FOCEXEC=......
ENDSTYLE

Best Regards,
Sandeep Mamidenna

Are you talking about conditional drill-downs using 'WHEN'?

If so, you have to DEFINE a field that contains the multiple conditions. e.g.:

DEFINE FILE CAR
DD1/A03 = IF SALES GT 1000 AND WHEELBASE GT 2 THEN 'YES' ELSE 'NO';
END
TABLE FILE CAR
SUM
DD1 NOPRINT
WHEELBASE NOPRINT
SALES/D10
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=CALLJSP (COUNTRY=COUNTRY), WHEN= DD1 EQ 'YES', $
ENDSTYLE
END
-RUN

quote:

Francis

Hi Francis,

Yes, it's the solution for me. Thank you

Best Regards,
B. H. Tang