Drill down doesn't work with "FOR" field

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

Posts: 90 | Location: Tinker AFB | Registered: June 03, 2003

Francis Mariani

Expert

posted

Hide Post

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

reFOCUSing

Guru

posted

Hide Post

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>,

Posts: 406 | Location: Canada | Registered: May 31, 2004

Ignored post by reFOCUSing posted

Show Post

Boogarweed

Gold member

posted

Hide Post

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

Posts: 90 | Location: Tinker AFB | Registered: June 03, 2003

Ignored post by Boogarweed posted

Show Post