I am trying to create hyper links from a graph which should bring the detail page for that section. I added parameter to the hyperlink and WHERE clause to the detail page so that I can get the detail for just the pie slice clicked. I have the files created with CAR example. The first file is the graph with hyper link. The second one is the detail.
But it gives me an error that (FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: JAPAN
I think there is a syntax issue with the parameter, but I am not sure what it is. Any help is appreciated.
Thank you.

-* File agalinks.fex
GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CAR.BODY.DEALER_COST
BY CAR.ORIGIN.COUNTRY
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 PIESINGL
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 0
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
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);
setPieDepth(10);
setPieFeelerTextDisplay(1);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN=N2, FOCEXEC=agasum(country=N1), $
ENDSTYLE
END
-RUN


-* File agasum.fex
TABLE FILE CAR
SUM
     'CAR.BODY.DEALER_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
HEADING
""
FOOTING
""
WHERE CAR.ORIGIN.COUNTRY EQ &country;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT, GRID=OFF, FONT='ARIAL',  SIZE=9,$
TYPE=TITLE, STYLE=BOLD,$
TYPE=TABHEADING, SIZE=12,  STYLE=BOLD,$
TYPE=TABFOOTING,   SIZE=12,     STYLE=BOLD,$
TYPE=HEADING,     SIZE=12,     STYLE=BOLD,$
TYPE=FOOTING,     SIZE=12,     STYLE=BOLD,$
TYPE=SUBHEAD,     SIZE=10,     STYLE=BOLD,$
TYPE=SUBFOOT,     SIZE=10,     STYLE=BOLD,$
TYPE=SUBTOTAL,     BACKCOLOR=RGB(210 210 210),$
TYPE=ACROSSVALUE,     SIZE=9,$
TYPE=ACROSSTITLE,     STYLE=BOLD,$
TYPE=GRANDTOTAL,     BACKCOLOR=RGB(210 210 210),     STYLE=BOLD,$
ENDSTYLE
END

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

Alpha values MUST be in quotes:

 
WHERE CAR.ORIGIN.COUNTRY EQ '&country';

 

Thanks Tom. That fixed the problem.

The hyperlinks work fine if the graph format is PNG. I need to use this graph in a compound document. When I add the graph to a compound document, the document composer tool changes the graph format to SVG and the hyperlinks do not work because the graph is an image now. Are there any workarounds for this problem. I really hope that this is not a limitation of compound document.
Thank you.