When I try to do a drill down on an EMR report, I need to pass the value of the field used in the "FOR" construct to the fex used in the drilldown. See example code:

SUM FIELD1 FIELD2
ACROSS FIELD3
FOR FIELD4 value1
value2

ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=FIELD1, FOCEXEC=availgen(COMMAND_PARM=FIELD3 MDS_PARM=FIELD4 TYPERPT='*** '),$
END
END

The value for field4 never gets passed. Any help would be appreciated....Kelly

You may need to refer to the column positionally instead of by column name - something to do with FRL:

SUM FIELD1 FIELD2
ACROSS FIELD3
FOR FIELD4 value1
value2

ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=FIELD1, FOCEXEC=availgen(COMMAND_PARM=FIELD3 MDS_PARM=C2 TYPERPT='*** '),$
END

Here is another way to do it (Francis beat me to it):

TABLE FILE CAR<br />SUM
 RETAIL_COST
DEALER_COST<br /> ACROSS
COUNTRY<br />FOR   
CAR'TOYOTA' OVER
'PEUGEOT' OVER
BMW'<br />ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=RETAIL_COST, FOCEXEC=fexname(var1=COUNTRY var2=p1),$
ENDSTYLE END
-RUN

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

Thanks all. Both solutions worked. Now I have to decide which one to use. It's always something. ;-)