Focal Point
BY FIELD VALUE TO DRILLDOWN REPORT

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4811056662

January 17, 2008, 03:33 PM
Kamesh
BY 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!!!


WFConsultant

WF 8105M on Win7/Tomcat
January 17, 2008, 04:41 PM
FrankDutch
suppose 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.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7