I have created a fex that makes a temporary FOCUS hold file and then graphs off of that file. I would like to use some of the fields in the hold file to filter off of on an HTML page. The graph is currently on an html page with the parameter dropdowns populated by the original master file. I would like them to instead be populated by the fex. When i set it to look at the fex it returns nothing in my dropdowns. I have tried to change the format to XML and was unsuccessful. I have created an example of my problem using the IBI car file.
Thanks for your help

Here is my code:

-* File cartest_parametersinagraph.fex
TABLE FILE CAR
BY 'CAR.BODY.BODYTYPE'
BY 'CAR.BODY.SEATS'
BY 'CAR.SPECS.WEIGHT'
WHERE CAR.BODY.BODYTYPE NE 'SEDAN';
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD111 FORMAT FOCUS
END
-*INTERNAL_PROPERTIES$fieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$enablePreview=true;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$prefixDisplayMode=;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
GRAPH FILE HOLD111
-* Created by Advanced Graph Assistant
SUM HOLD111.SEG01.WEIGHT
BY HOLD111.SEG01.BODYTYPE
WHERE HOLD111.SEG01.BODYTYPE EQ '&BODYTYPE';
WHERE HOLD111.SEG01.SEATS EQ '&SEATS';
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
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 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),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);
setPlace(true);
ENDSTYLE
END

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

Normally, a hold file is created in a temp directory. Once the final report is built, then the file is deleted. That is why you cannot find it for you drop downs.

Create the hold file in the foccache directory to keep it around for the duration of your session.

Remember, the hold file must be created before the html page is presented to the user or there still will not be anything available to use.

Thanks for the advise. I was able to accomplish this by making a fex that was used to populate my dashboards. This fex was seperate from my graph.

Thanks Again
Kevin