When I run a graph procedures via the Report Caster, I get 4 separate files, one for each graph where as when I run the same graph procedure in Dev Studio or from the html layout on our Dashboard, I get all 4 graph on one page. Can all 4 graphs be displayed in 1 file when I run 1 graph procedure containing the 4 graphs via the Report Caster?This message has been edited. Last edited by: Kerry,
7.6.8, Windows XP Excel, PDF, Active HTML, HTML, PDF
June 01, 2010, 10:05 AM
Prarie
Yes it can. Will you post your code please.
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
June 02, 2010, 11:01 AM
BKR
The code is shown below and thanks for your help:
-*File Trends Graph Month.fex -SET &ECHO=ALL; SET ALL=ON SET NODATA='0.00' APP HOLD BASEAPP -DEFAULT &TIME_FIELD='TIME_DIM_MONTH'; -DEFAULT &TIME_SORT='FOC_NONE'; TABLE FILE DM_HOURS_COST_FACT SUM SICK_HOURS_DOLLARS OVERTIME_HOURS_DOLLARS BY &CATEGORY.(,,,,,).CATEGORY. -IF &TIME_FIELD NE FISCAL_YEAR GOTO TIME_DIM_QTR; BY TIME_DIM_MONTH -SET &TIME_FIELD='E01'; -SET &TIME_SORT ='BY E02'; -GOTO REPORT1 -TIME_DIM_QTR -IF &TIME_FIELD NE FISCAL_QUARTER GOTO TIME_DIM_MTH; -*BY FISCAL_YEAR BY FISCAL_QUARTER BY FISCAL_YEAR BY FISCAL_QUARTER BY TIME_DIM_QUARTER_NAME -SET &TIME_FIELD='E02'; -SET &TIME_SORT ='BY E02 BY E03 NOPRINT BY E04 AS Fiscal_Quarter'; -GOTO REPORT1 -TIME_DIM_MTH -*BY FISCAL_YEAR BY FISCAL_QUARTER BY TIME_DIM_MONTH BY FISCAL_YEAR BY TIME_DIM_MONTH BY TIME_DIM_MONTH_NUM_NAME -SET &TIME_FIELD='E03'; -SET &TIME_SORT ='BY E02 BY E03 NOPRINT BY E04 AS Fiscal_Month'; -REPORT1 FOOTING "" WHERE ( FISCAL_YEAR NE 2005 ) AND ( FISCAL_YEAR NE 2006 ); ON TABLE HOLD AS HOLD1 FORMAT ALPHA END -*? HOLD HOLD1 -*-EXIT -* DEFINE FILE HOLD1 -* Change the datatype to I4 FYI4/I4=FISCAL_YEAR; -* Change it to I4 with a 2-digit year display format FYI4YY/I4YY=FYI4; -* Then, change it to just a 2-digit year format FISCAL_YEAR_NEW/YY=FYI4YY; END GRAPH FILE HOLD1 SUM SICK_HOURS_DOLLARS AS 'SICK DOL' OVERTIME_HOURS_DOLLARS AS 'OT DOL' BY FISCAL_YEAR ACROSS TIME_DIM_MONTH_NUM_NAME AS 'MONTH' HEADING "Fiscal Trend Dollars by Month" "ON GRAPH SET LOOKGRAPH VLINE 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 185.000 ON GRAPH SET HAXIS 400.000 ON GRAPH SET UNITS PIXELS ON GRAPH SET GRWIDTH 1 ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET GRAPHSTYLE * setTransparentBorderColor(getSeries(0),true); setTransparentBorderColor(getSeries(1),true); setTransparentBorderColor(getSeries(10),true); setTransparentBorderColor(getSeries(11),true); setTransparentBorderColor(getSeries(12),true); setTransparentBorderColor(getSeries(13),true); setTransparentBorderColor(getSeries(14),true); setTransparentBorderColor(getSeries(15),true); setTransparentBorderColor(getSeries(16),true); setTransparentBorderColor(getSeries(17),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(18),true); setTransparentBorderColor(getSeries(19),true); setTransparentBorderColor(getSeries(20),true); setTransparentBorderColor(getSeries(21),true); setTransparentBorderColor(getSeries(22),true); setTransparentBorderColor(getSeries(23),true); setTransparentBorderColor(getSeries(24),true); setTransparentBorderColor(getSeries(25),true); setTransparentBorderColor(getSeries(26),true); setTransparentBorderColor(getSeries(27),true); setTransparentBorderColor(getSeries(28),true); setTransparentBorderColor(getSeries(29),true); setTransparentBorderColor(getSeries(30),true); setTransparentBorderColor(getSeries(31),true); setTransparentBorderColor(getSeries(32),true); setTransparentBorderColor(getSeries(33),true); setTransparentBorderColor(getSeries(34),true); setTransparentBorderColor(getSeries(35),true); setTransparentBorderColor(getSeries(36),true); setTransparentBorderColor(getSeries(37),true); setTransparentBorderColor(getSeries(38),true); setTransparentBorderColor(getSeries(39),true); setTransparentBorderColor(getSeries(40),true); setTransparentBorderColor(getSeries(41),true); setTransparentBorderColor(getSeries(42),true); setTransparentBorderColor(getSeries(43),true); setTransparentBorderColor(getSeries(44),true); setTransparentBorderColor(getSeries(45),true); setTransparentBorderColor(getSeries(46),true); setTransparentBorderColor(getSeries(47),true); setTransparentBorderColor(getSeries(48),true); setTransparentBorderColor(getSeries(49),true); setTransparentBorderColor(getSeries(50),true); setTransparentBorderColor(getSeries(51),true); setTransparentBorderColor(getSeries(52),true); setTransparentBorderColor(getSeries(53),true); setTransparentBorderColor(getSeries(54),true); setTransparentBorderColor(getSeries(55),true); setTransparentBorderColor(getSeries(56),true); setTransparentBorderColor(getSeries(57),true); setTransparentBorderColor(getSeries(58),true); setTransparentBorderColor(getSeries(59),true); setTransparentBorderColor(getSeries(60),true); setTransparentBorderColor(getSeries(61),true); setTransparentBorderColor(getSeries(62),true); setTransparentBorderColor(getSeries(63),true); setDepthRadius(0); setDepthAngle(0); setLineWidthAllSeries(2); setSeriesLineWidthDefault(2); setExtendToFrameEdge(true); setBorderColor(getFrame(),new Color(192,192,192)); setBorderColor(getSeries(0),new Color(0,63,160)); setFillColor(getSeries(1),new Color(190,205,235)); setFontSizeInPoints(getLegendText(),9); setDisplay(getLegendArea(),false); setFontSizeInPoints(getO1Title(),9); setFontSizeInPoints(getO1Label(),9); setLineWidth(getO1MajorGrid(),1); setLineBasicStrokeType(getO1MajorGrid(),11); setBorderColor(getO1MajorGrid(),new Color(0,0,0)); setFillColor(getO1MajorGrid(),new Color(0,0,0)); setLineWidth(getY1MajorGrid(),1); setLineBasicStrokeType(getY1MajorGrid(),11); setFillColor(getY1MajorGrid(),new Color(192,192,192)); setBorderColor(getY1MajorGrid(),new Color(192,192,192)); setFontSizeInPoints(getY1Label(),9); setLabelStagger(getY1Label(),false); setDisplay(getY1AxisLine(),false); setReportParsingErrors(false); setSelectionEnableMove(false); setTextString(getO1Title(),""); setTransparentBorderColor(getChartBackground(),true); setBorderColor(getY1MajorGrid(),new Color(128,128,128)); setFillColor(getY1MajorGrid(),new Color(128,128,128)); setBorderColor(getO1MajorGrid(),new Color(128,128,128)); setFillColor(getO1MajorGrid(),new Color(128,128,128)); setFillColor(getSeries(0),new Color(255,0,0)); setLineWidth(getSeries(0),2); setBorderColor(getSeries(1),new Color(0,129,0)); setLegendTextAutosize(true); setLegendMarkerPosition(4); setMarkerDisplay(false); setConnectLineMarkers(true); setConnectScatterMarkers(true); setO1LabelDisplay(true); setO1AxisSide(0); setO1MajorGridDisplay(true); setO1MajorGridStyle(0); setO1MinorGridDisplay(false); setAxisAssignment(0,0); setSeriesType(0,2); setAxisAssignment(1,0); setSeriesType(1,2); setY1LabelDisplay(true); setY1AxisSide(0); setY1MajorGridDisplay(true); setY1MajorGridStyle(0); setY1MinorGridDisplay(false); setTextFormatPreset(getY1Label(),-1); setTextFormatPattern(getY1Label(),"#.##"); setPieFeelerTextDisplay(1); setPieLabelDisplay(0); setTextFormatPreset(getPieSliceLabel(),1); setLegendDisplay(true); setTextJustHoriz(getLegendText(),2); setFontName(getLegendText(),"Calibri"); setLegendTextAutofit(true); setFontSizeAbsolute(getY1Title(),true); setFontSizeAbsolute(getY1Label(),true); setFontSizeAbsolute(getY2Title(),true); setFontSizeAbsolute(getY2Label(),true); setFontSizeAbsolute(getO1Title(),true); setFontStyle(getO1Title(),0); setTextJustHoriz(getO1Label(),1); setFontSizeAbsolute(getO1Label(),true); setTextRotation(getO1Label(),1); setPlace(false); ENDSTYLE ON GRAPH SET STYLE * SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $ TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=11, COLOR='BLACK', STYLE=BOLD, $ TYPE=HEADING, LINE=2, SIZE=9, COLOR='BLACK', $ TYPE=HEADING, LINE=2, OBJECT=FIELD, ITEM=1, SIZE=10, $ ENDSTYLE END
7.6.8, Windows XP Excel, PDF, Active HTML, HTML, PDF
June 02, 2010, 11:07 AM
Francis Mariani
I only see one graph here, or am I misinterpreting your code?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 03, 2010, 09:09 AM
BKR
From this procedure, I get 4 graphs, one for each Fiscal year: 1. 2007 2. 2008 3. 2009 4. 2010
7.6.8, Windows XP Excel, PDF, Active HTML, HTML, PDF
Nice try Tom, I copied and pasted ON GRAPH SET GRMERGE ON in the procedure with the other ON GRAPH SET commands but, when I run the procedure via Report Caster I still get 4 separate graph files.
7.6.8, Windows XP Excel, PDF, Active HTML, HTML, PDF