June 16, 2008, 04:47 AM
soujiMultiple parameters passing on drilldown
I have a report that contians 2 drilldowns.
I have to drill on dates in FIRST report(Both title and data) it works fine.
But in my second drilldown,iam passing 2 parameters PUSH_D and RDC
Here my problem was Iam not able to pass the two parameters.In this i have a drilldown on data such that it should go to specific field RDC.
Here is my sAMPLE CODE
FIRST.FEX
-DEFAULT &PUSH_D = 'FOC_NONE';
TABLE FILE SAVDATES
SUM
CARTONS
CARTONS1
BY PUSH_D
TYPE=DATA,
COLUMN=N1,
BORDER=LIGHT,
SIZE=8,
BACKCOLOR=( 'WHITE' 'SILVER' ),
FOCEXEC=app/SECOND(PUSH_D=PUSH_D),
$
TYPE=TITLE,
COLUMN=N1,
BORDER=LIGHT,
SIZE=8,
COLOR='WHITE',
BACKCOLOR='SILVER',
STYLE=BOLD,
FOCEXEC=app/SECOND, -*here i didnt pass any variable but it is working.
$
SECOND FEX
-DEFAULT &RDC = 'FOC_NONE;'
TABLE FILE DYLSUM
-*ON TABLE SET NODATA ' '
SUM
CARTONS
BY RDC
ACROSS PUSH_D
TYPE=DATA,
COLUMN=N1,
BORDER=LIGHT,
SIZE=8,
BACKCOLOR=( 'WHITE' 'SILVER' ),
JUSTIFY=LEFT,
FOCEXEC=app/eos3(PUSH_D='&DATES' RDC='&RDC.EVAL'),
$
TABLE FILE DYLSUM
SUM
CARTONS BY RDC
BY DEPT_I
ACROSS PUSH_D
END
Here iam getting for all RDC values iam getting.But i want specific
Thanks in advance.
June 16, 2008, 09:16 AM
GinnyJakesSouji,
You have to put a WHERE clause in the child focexecs that test the field against the parameter passed. I don't see any WHERE clauses in any of these reports.
This is not magic; you have to ask WF for what you want.