3D Bar-Line Combination Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Bar-Line Combination 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, 75 as s1, 35 as s2
union
select 2 as category, 45 as s1, 55 as s2
union
select 3 as category, 55 as s1, 90 as s2
union
select 4 as category, 45 as s1, 45 as s2
union
select 5 as category, 65 as s1, 85 as s2
union
select 6 as category, 40 as s1, 60 as s2
union
select 7 as category, 80 as s1, 35 as s2
union
select 8 as category, 45 as s1, 55 as s2
union
select 9 as category, 45 as s1, 90 as s2
union
select 10 as category, 20 as s1, 45 as s2
GO
.setResultSettings 'Index=1,
       CategoryFields="[category]",
       SeriesFields="[s2],[s1]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{line,column}",
       RotX=321,
       RotY=-23,
       RotZ=0,
       ZoomScalar=0.9841375,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="3D Bar Line Combination 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=4.0,
       SeriesSpacing=1.0,
       CategorySpacing=1.0,
       Font=Arial-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.899998,
       PanY=-3.0000007,
       Lighting=Default,
       Opacity=0.8,
       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=false,
       SeriesAlias="default,default",
       SeriesSubType=",",
       SeriesColumnType="Cube,Cube",
       SeriesMin="default,default",
       SeriesMax="default,default",
       SeriesColor="#993300,#3366ff",
       SeriesFunctionMetaData="true,true",
       ShowSeriesDataLabels="false,false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=false,
       FixedCategoryCount=1'