-* File GroupColoredGraph.fex GRAPH FILE CAR SUM CAR.BODY.DEALER_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH HBAR ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 2 ON GRAPH SET GRAPHSTYLE * setTemplateFile("/images/tdg/template/IBISouthWestern.txt"); setReportParsingErrors(false); setSelectionEnableMove(false); 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); setDepthRadius(5); setTransparentBorderColor(getChartBackground(),true); setPlace(true); ENDSTYLE ENDThis message has been edited. Last edited by: M. Meagher,
ON GRAPH SET STYLE * SQUEEZE=ON, ORIENTATION=PORTRAIT,$ DEFMACRO=COND0001, MACTYPE=RULE, WHEN=N1 EQ 'AUDI',$ DEFMACRO=COND0002, MACTYPE=RULE, WHEN=N1 EQ 'JAGUAR',$ DEFMACRO=COND0003, MACTYPE=RULE, WHEN=N1 EQ 'BMW',$ DEFMACRO=COND0004, MACTYPE=RULE, WHEN=N1 EQ 'MASERATI',$ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10,$ TYPE=DATA, COLOR=RGB(240 240 240),$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0001, COLOR=RED,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0002, COLOR=GREEN,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0003, COLOR=BLUE,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0004, COLOR=BLUE,$ ENDSTYLE
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
GRAPH FILE CAR -* Created by Advanced Graph Assistant SUM CAR.BODY.DEALER_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH HBAR ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 2 ON GRAPH SET STYLE * DEFMACRO=COND0001, MACTYPE=RULE, WHEN=N1 EQ 'AUDI',$ DEFMACRO=COND0002, MACTYPE=RULE, WHEN=N1 EQ 'JAGUAR',$ DEFMACRO=COND0003, MACTYPE=RULE, WHEN=N1 EQ 'BMW',$ DEFMACRO=COND0004, MACTYPE=RULE, WHEN=N1 EQ 'MASERATI',$ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10,$ TYPE=DATA, COLOR=RGB(240 240 240),$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0001, COLOR=RED,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0002, COLOR=GREEN,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0003, COLOR=BLUE,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0004, COLOR=BLUE,$ ENDSTYLE END
TABLE FILE CAR BY CAR ON TABLE HOLD END -RUN -SET &NumberOfSeries = &LINES * 1 ; -TYPE We have &NumberOfSeries cars to graphs... -SET &NumberOfSeries = &NumberOfSeries - 1 ; -SET &LoopCounter = 0 ; GRAPH FILE CAR SUM MAX.CAR.BODY.SEATS ACROSS CAR.COMP.CAR BY CAR.COMP.CAR ON GRAPH SET LOOKGRAPH VBAR ON GRAPH SET GRAPHEDIT SERVER ON GRAPH SET BARNUMB OFF ON GRAPH SET 3D OFF ON GRAPH SET VZERO ON ON GRAPH SET GRID ON ON GRAPH SET VAXIS 600 ON GRAPH SET HAXIS 900 ON GRAPH SET GRMERGE 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); 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); setTextJustHoriz(getLegendText(),1); setFontSizeAbsolute(getLegendText(),true); setFontSize(getLegendText(),10); setTextRotation(getLegendText(),0); setTextWrap(getLegendText(),false); setFontSizeAbsolute(getY1Title(),true); setFontSizeAbsolute(getY1Label(),true); setFontSizeAbsolute(getY2Title(),true); setFontSizeAbsolute(getY2Label(),true); setFontSizeAbsolute(getO1Title(),true); setPlaceResize(getLegendText(),0); setPlaceRotate(getLegendText(),0); setPlaceAlign(getLegendText(),0); setPlaceWordWrap(getLegendText(),0); setPlace(true); -* THE FOLLOWING LOOP DOES THE SAME THING AS THE STYLESHEET ITEMS BELOW. -*-REPEAT EndOfLoop FOR &LoopCounter FROM 0 TO &NumberOfSeries ; -*-SET &ThisColor = '000,000,255' ; -*setFillColor(getSeries( &LoopCounter ), new Color( &ThisColor )); -*-EndOfLoop -* Display a legend or not (true or false) -*setLegendDisplay(false); ENDSTYLE ON GRAPH SET STYLE * SQUEEZE=ON, ORIENTATION=PORTRAIT,$ DEFMACRO=COND0001, MACTYPE=RULE, WHEN=N1 EQ 'AUDI',$ DEFMACRO=COND0002, MACTYPE=RULE, WHEN=N1 EQ 'JAGUAR',$ DEFMACRO=COND0003, MACTYPE=RULE, WHEN=N1 EQ 'BMW',$ DEFMACRO=COND0004, MACTYPE=RULE, WHEN=N1 EQ 'MASERATI',$ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10,$ TYPE=DATA, COLOR=RGB(240 240 240),$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0001, COLOR=RED,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0002, COLOR=GREEN,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0003, COLOR=BLUE,$ TYPE=DATA, ACROSSCOLUMN=N1, MACRO=COND0004, COLOR=BLUE,$ ENDSTYLE END -RUN
TABLE FILE CAR BY COUNTRY ON TABLE HOLD END -RUN -SET &NumberOfSeries = &LINES * 1 ; -TYPE We have &NumberOfSeries cars to graphs... -SET &NumberOfSeries = &NumberOfSeries - 1 ; -SET &LoopCounter = 0 ; -RUN GRAPH FILE CAR SUM CAR.BODY.DEALER_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH HBAR ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 2 ON GRAPH SET GRAPHSTYLE * setTemplateFile("/images/tdg/template/IBISouthWestern.txt"); setReportParsingErrors(false); setSelectionEnableMove(false); 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); setDepthRadius(5); setTransparentBorderColor(getChartBackground(),true); setPlace(true); -* THE FOLLOWING LOOP DOES THE SAME THING AS THE STYLESHEET ITEMS BELOW. -REPEAT EndOfLoop FOR &LoopCounter FROM 0 TO &NumberOfSeries ; -SET &ThisColor = '000,000,255' ; setFillColor(getSeries( &LoopCounter ), new Color( &ThisColor )); -EndOfLoop -* Display a legend or not (true or false) setLegendDisplay(false); ENDSTYLE END -RUN
-* File GroupColoredGraph.fex GRAPH FILE CAR -* Created by Advanced Graph Assistant SUM CAR.BODY.DEALER_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH HBAR ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 2 ON GRAPH SET GRAPHSTYLE * -*setTemplateFile("/images/tdg/template/IBISouthWestern.txt"); setReportParsingErrors(false); setSelectionEnableMove(false); 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); setTransparentBorderColor(getChartBackground(),true); setPlace(true); ENDSTYLE ON GRAPH SET STYLE * DEFMACRO=COND0001, COLOR=RGB(255 255 0), WHEN=COUNTRY EQ 'JAPAN', $ DEFMACRO=COND0002, COLOR=RGB(0 100 0), WHEN=COUNTRY EQ 'ENGLAND', $ DEFMACRO=COND0003, COLOR=RGB(255 0 255), WHEN=COUNTRY EQ 'FRANCE', $ DEFMACRO=COND0004, COLOR=RGB(220 20 60), WHEN=COUNTRY EQ 'ITALY', $ DEFMACRO=COND0005, COLOR=RGB(255 215 0), WHEN=COUNTRY EQ 'W GERMANY', $ TYPE=REPORT, FONT='TIMES NEW ROMAN', SIZE=10, GRID=OFF, SQUEEZE=ON, $ TYPE=DATA, COLUMN=DEALER_COST, MACRO=COND0001, $ TYPE=DATA, COLUMN=DEALER_COST, MACRO=COND0002, $ TYPE=DATA, COLUMN=DEALER_COST, MACRO=COND0003, $ TYPE=DATA, COLUMN=DEALER_COST, MACRO=COND0004, $ TYPE=DATA, COLUMN=DEALER_COST, MACRO=COND0005, $ ENDSTYLE END