3D Area Zero Axis Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Area Zero Axis 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, 60 as s1, -40 as s2, 40 as s3
union
select 2 as category, 50 as s1, -35 as s2, 35 as s3
union
select 3 as category, 95 as s1, -55 as s2, 55 as s3
union
select 4 as category, 65 as s1, -40 as s2, 40 as s3
union
select 5 as category, 90 as s1, -25 as s2, 25 as s3
union
select 6 as category, 60 as s1, -20 as s2, 40 as s3
union
select 7 as category, 80 as s1, -33 as s2, 33 as s3
union
select 8 as category, 85 as s1, 0 as s2, 45 as s3
union
select 9 as category, 75 as s1, 50 as s2, -50 as s3
union
select 10 as category, 100 as s1, 40 as s2, -40 as s3
GO
.setResultSettings 'Index=1,
       CategoryFields="[category] ASC",
       SeriesFields="[s1],[s2],[s3]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{area,area,area}",
       RotX=324,
       RotY=-35,
       RotZ=0,
       ZoomScalar=1.5641373,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="3D Area Zero Axis 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=5.0,
       SeriesSpacing=0.5,
       CategorySpacing=0.5,
       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=-36.300003,
       PanY=90.3,
       Lighting=Default,
       Opacity=0.9,
       View2D=false,
       FitChartToImage=false,
       StackedPercent=false,
       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",
       SeriesSubType=",,",
       SeriesColumnType="Cube,Cube,Cube",
       SeriesMin="default,default,default",
       SeriesMax="default,default,default",
       SeriesColor="#40699d,#9f413e,#ffcc00",
       SeriesFunctionMetaData="true,true,true",
       ShowSeriesDataLabels="false,false,false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=true,
       FixedCategoryCount=0'