Helo Guys, Tried all Graph options available in Advanced Graph Assistant. Can not create this type of graph. Any suggestions are appreciated. Below link shows Sample image I'm trying to recreate.
ThanksThis message has been edited. Last edited by: TryFocus,
Prod: WF 7.6.10 windows. -- MRE/Dashboard/Self Service/ReportCaster - Windows XP
March 24, 2013, 05:09 AM
Danny-SRL
Have a try at this:
DEFINE FILE GGSALES
YEAR/YY=DATE;
DOLLARS96/D6=IF YEAR EQ 1996 THEN DOLLARS ELSE 0;
DOLLARS97/D6=IF YEAR EQ 1997 THEN DOLLARS ELSE 0;
END
-* Created by Advanced Graph Assistant
SUM
DOLLARS96 AS '1996'
DOLLARS97 AS '1997'
BY GGSALES.SALES01.REGION
BY GGSALES.SALES01.CATEGORY
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 VBAR
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);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
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);
setPlace(true);
ENDSTYLE
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 29, 2013, 02:36 PM
TryFocus
Thank you Danny. You sample code helped me to fix the issue.
Prod: WF 7.6.10 windows. -- MRE/Dashboard/Self Service/ReportCaster - Windows XP