3D Cone Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Cone Chart
--
--   Notes: The query below will work on the following database servers:
--          MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, MySQL, PostreSQL
--
--   ORACLE: To make the query below work in Oracle, add " FROM DUAL" at the end of each SELECT         
--   DB2: To make the query below work in DB2, add " FROM SYSIBM.SYSDUMMY1" at the end of each SELECT
-------------------------------------------------------------------------------------------------------------------------------------------------------------

select 1 as category, 28 as s1, 20 as s2, 30 as s3, 28 as s4
union
select 2 as category, 24 as s1, 22 as s2, 26 as s3, 24 as s4
union
select 3 as category, 20 as s1, 24 as s2, 25 as s3, 20 as s4
union
select 4 as category, 22 as s1, 25 as s2, 27 as s3, 22 as s4
union
select 5 as category, 28 as s1, 24 as s2, 28 as s3, 18 as s4
GO
.setResultSettings 'Index=1,
       CategoryFields="[category] ASC",
       SeriesFields="[s1],[s2],[s3],[s4]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{column,column,column,column}",
       RotX=331,
       RotY=-26,
       RotZ=0,
       ZoomScalar=0.92487824,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="3D Cone Chart",
       TitlePosition="Bottom Center",
       TitleCategory="",
       TitleValue="",
       PieExplode=0.0,
       GroupSmallValues=true,
       SmallValuesThreshold=3.0,
       PieLabelDistance=3.0,
       PieShowLines=false,
       LineWidth=1.0,
       ShowMarkers=true,
       MapShowBackground=false,
       MapShowDetails=false,
       MapRange="",
       MapRangeColors="",
       Width=16.0,
       Height=10.0,
       Depth=10.0,
       SeriesSpacing=1.0,
       CategorySpacing=1.0,
       Font=Arial-PLAIN-6,
       LegendFontSize=1.0,
       SeriesFontSize=1.0,
       CategoryFontSize=1.0,
       ValueFontSize=1.0,
       TitleFontSize=1.75,
       AxisTitleFontSize=1.25,
       DataLabelFontSize=1.0,
       TopColor=#d7dcf5,
       BottomColor=#ebf0f5,
       PanX=-8.199998,
       PanY=-1.399999,
       Lighting=Ambient,
       Opacity=0.9,
       View2D=false,
       FitChartToImage=false,
       StackedPercent=true,
       ShowValueAxis=true,
       ShowValueAxisTicks=true,
       ShowValueAxisLines=true,
       ReverseValueAxis=false,
       ShowCategoryAxis=true,
       ShowCategoryAxisTicks=true,
       ShowCategoryAxisLines=true,
       ShowSeriesAxis=false,
       ShowDataLabels=false,
       ValueAxisNumberFormat="###0",
       CategoryAxisNumberFormat="#,##0",
       CategoryAxisDateFormat="",
       CategoryAxisDateTimeFormat="",
       CategoryAxisTimeFormat="",
       SeriesAxisNumberFormat="",
       SeriesAxisDateFormat="",
       SeriesAxisDateTimeFormat="",
       SeriesAxisTimeFormat="",
       NumericCategoryAxis=false,
       MergeAxis=true,
       SeriesAlias="default,default,default,default",
       SeriesSubType=",,,",
       SeriesColumnType="Cone,Cone,Cone,Cone",
       SeriesMin="default,default,default,default",
       SeriesMax="default,default,default,default",
       SeriesColor="#333333,#afe800,#993300,#3366ff",
       SeriesFunctionMetaData="true,true,true,true",
       ShowSeriesDataLabels="false,false,false,false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=true,
       FixedCategoryCount=0'