[SOLVED]: EXPANDBYROW DRILL-DOWN

HI,
Cant seem to figure out how to add drill-down. Tried a few things but cant seem to make it work. Is it a known issue. I searched it on the forum as well and didnt find anything.
Here is the syntax I am using:

TYPE=DATA,
COLUMN=N6,
FOCEXEC=IBFS:/WFC/Repository/.../DrillDown.fex,
$

Thanks

This message has been edited. Last edited by: BM,

WebFOCUS 8202M

Posts: 167 | Location: Montreal | Registered: September 23, 2014

MartinY

Virtuoso

posted

Hide Post

It does work, but only on the last BY field.
If COLUMN=N6 is not the last BY it doesn't work.

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDBYROW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA,
   COLUMN=MODEL,
   FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex,
$
END

-* Procedure2
TABLE FILE CAR
PRINT *
END

Or with using parameters (which make more sense)

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDBYROW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA,
   COLUMN=MODEL,
   FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex (FCOUNTRY=COUNTRY FCAR=CAR FMODEL=MODEL),
$
END

-* Procedure2
TABLE FILE CAR
PRINT *
WHERE COUNTRY EQ '&FCOUNTRY';
WHERE CAR     EQ '&FCAR';
WHERE MODEL   EQ '&FMODEL';
END

This message has been edited. Last edited by: MartinY,

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Show Post

Platinum Member

posted

Hide Post

Thanks but COLUMN N6 is a measure.

Basically, I want to do something like the example below.

quote:
TABLE FILE CAR
SUM SALES
DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDBYROW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA,
COLUMN=SALES,
FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex (FCOUNTRY=COUNTRY FCAR=CAR FMODEL=MODEL),
$

TYPE=DATA,
COLUMN=DCOST,
FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex (FCOUNTRY=COUNTRY FCAR=CAR FMODEL=MODEL),
$

END