October 20, 2007, 06:06 PM
Don RobisonMutil drill down from a Html page
I am trying to create a html page with a graph. What I needing to know is if I
can have a multi drill down link in one graph.
Any help would greatly be appreciated
GRAPH FILE TMAXTRCT
SUM Total_Cost AS 'Business Function'
ACROSS FUNCTION_NAME
WHERE STATUS NE 'C';
-*SUM COMPUTE Total_Cost/D20.2=( TODATE_COST + EST_COST );
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 SET VAXIS 560
ON GRAPH SET HAXIS 510
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);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(1);
setTextFormatPreset(getPieSliceLabel(),4);
setLegendDisplay(true);
setTitleString("All Service Requsets by Function");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setTemplateFile("/images/tdg/template/IBITrueColors.txt");
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,
TITLETEXT='All Service Requsets by Function',
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END
October 21, 2007, 12:51 PM
Majid JeddiHi,
Yes you can have Multiple Drill down.
You need to select the first field that you want to use as HyperLink and click on the drill down botton then follow the instruction.
Then select the second the second field and do the same as you did in the first step.
This assumes that you are calling different procedures with these 2 drill downs otherwsie there is no need to have multiple dilldown.
If this is not what you were expecting please give more detail.
Majid.
October 22, 2007, 05:15 AM
FrankDutchquote:
Originally posted by Tom Flynn:
Yes
Tom, I think this is not the answer somebody wants.
I think also that the answer should be NO...
October 22, 2007, 09:48 AM
<VenuPalvai>Yes, You can have multiple drilldowns from a graph.
Create the following under one of the application folders in app path.
Notice the IBIF_ex= parameter in JS file. You can call different programs by changing the value of the parameter.
-* 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
-* do not include comments in the js file
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');
-* end popup_box.js
-*
popup_box.css
#POPUP {
font-size: 9pt;
font-family: arial;
font-weight: bold;
padding: 5px;
text-align: left;
vertical-align: top;
background-color: rgb(231,231,231);
border: outset 2;
visibility: hidden;
position: absolute;
width: 200px;
}