January 17, 2008, 03:33 PM
KameshBY FIELD VALUE TO DRILLDOWN REPORT
I am trying to pass the parameters to drilldown report but unfortunately I am not able to send the value for the whole period.
Ex:
Make Period Model Count
Toyota 1/1/2004 to 1/1/2005 CAMRY 5
COROLLA 6
1/1/2005 to 1/1/2006 CAMRY 8
COROLLA 10
1/1/2006 TO 1/1/2007 CAMRY 3
COROLLA 0
When I click the Toyota, it should pass the value for Make, Period, Model and Count. For Period I want to pass from 1/1/2004 to 1/1/2007 but unfortunately it passes only 1/1/2004 to 1/1/2005.
Anybody know, how to get around this?
Thanks for your help!!!
January 17, 2008, 04:41 PM
FrankDutchsuppose your parent report has only these 4 fields in the report, I think your from and to (the period) is build on two fields.
TABLE FILE XXX
PRINT
MAKE
FROMF NOPRINT
TOF NOPRINT
PERIOD
MODEL
COUNT
....
the call for the child report would be
FOCEXEC=child.fex(make=N1 FROMF=N2 TOF=N3 MODEL=N5 COUNT=N6)
etc...
In the define you create your PERIOD field before.