Is there a way to create multiple drill downs for graphs created with the Advanced Graph Assistant, like you can in the Report Painter, so when it runs and you click on a drill-down value, you get the pop-up menu that lists the child reports?

Thank you,

John

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

I'm pretty sure this cannot be done. See these previous posts:

Post 1

Post 2

Search on DRILLMENUITEM and GRAPH in the Advanced Search.

We are able to multiple drilldown menu options from graphs using the following.



Copy below in an app folder.

---*

-* File popup_box_test.fex
SET JSURL=/approot/html/popup_box.js
SET CSSURL=/approot/html/popup_box.css
DEFINE FILE GGSALES
POPUP_BOX/A100='';
END
GRAPH FILE GGSALES
SUM UNITS
ACROSS PRODUCT
HEADING
"ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
JAVASCRIPT=showPopup(A1),
$
ENDSTYLE
END


--****
-* File popup_box_drill1.fex

TABLE FILE GGSALES
SUM UNITS DOLLARS
BY PRODUCT
BY REGION
WHERE PRODUCT EQ '&PARMVALUE'
END


---** popup_box.js
var topX, topY;

function getXY() {

topX = event.clientX ;
topY = event.clientY ;
}

function getXOffset(offset) {
docWidth=document.body.clientWidth;
newOffset;

if (topX > (docWidth / 2))
newOffset=offset*-1;
else
newOffset = offset;
return newOffset;
}

function getYOffset(offset) {
docHeight=document.body.clientHeight;
newOffset;

if (topY > (docHeight / 2))
newOffset=offset*-1;
else
newOffset = offset;
return newOffset;
}

function showPopup(inVal) {

/* getXY();
xOff=getXOffset(objId.style.pixelWidth);
yOff=getYOffset(objId.style.pixelHeight);
*/
objId=document.getElementById('POPUP');
objId.style.pixelTop = 3;
objId.style.pixelLeft = 3;
text1 = 'Drilldown 1 for ' + inVal + '
';
text2 = 'Drilldown 2 for ' + inVal + '
';
objId.innerHTML = text1 + text2;
objId.style.visibility='visible';
}

function hidePopup() {
objId=document.getElementById('POPUP');
objId.style.visibility='hidden';
}


--***** popup_box.css
#POPUP {
font-size: 9pt;
font-family: arial;
font-weight: bold;
padding: 5px;
text-align: left;
vertical-align: top;
background-color: rgb(192,192,192);
border: outset 2;
visibility: hidden;
position: absolute;
width: 200px;
}