I'm using advanced Graph assistant to create a Clustered Graph and then drill on a selected BAR from that Graph. WebFocus is only allowing the passing of 2 variables to the drilldown. When you add the third the first one works and the second and third assume the value of the third.

GRAPH FILE CAR
SUM SEATS
BY COUNTRY NOPRINT
BY CAR
BY MODEL
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setPlace(true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN=N4, FOCEXEC=Test3(MODEL=N3 CAR=N2 COUNTRY=N1), $
ENDSTYLE
END

Test3.fex
-TYPE COUNTRY == &COUNTRY
-TYPE CAR == &CAR
-TYPE MODEL == &MODEL
-EXIT

TABLE FILE CAR
PRINT SALES
BY COUNTRY
BY CAR
BY MODEL
WHERE COUNTRY EQ '&COUNTRY';
WHERE CAR EQ '&CAR';
WHERE MODEL EQ '&MODEL';
END

This looks like a bug. You can open a case by calling 1800-736-6130 or going to http://techsupport.informationbuilders.com/ and using Case Management

Tom, The problem with that solution is that you are summing seats and model. You will only get the first one per car.

Spence,

Try concatenating the Car and Model together.

DEFINE FILE CAR
MAKEMODL/A30=CAR||(', '|MODEL);
END
GRAPH FILE CAR
SUM SEATS
BY COUNTRY NOPRINT
BY MAKEMODL
...
END
THEN PASS MAKEMODL if you need the CAR and MODEL separated in the next step you can break it apart again using GETTOK.

thanks pat. that will work for me.

i think there is a problem with not being able to pass more than 2 variables.