3D Oblique Bar Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Oblique Bar 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, 3000 as s1, 1200 as s2, 1000 as s3, 500 as s4
union
select 2 as category, 4000 as s1, 300 as s2, 1500 as s3, 1000 as s4
union
select 3 as category, 1000 as s1, 800 as s2, 1200 as s3, 600 as s4
union
select 4 as category, 4000 as s1, 1200 as s2, 1500 as s3, 700 as s4
union
select 5 as category, 1000 as s1, 800 as s2, 900 as s3, 300 as s4
union
select 6 as category, 5000 as s1, 1000 as s2, 1300 as s3, 500 as s4
union
select 7 as category, 1300 as s1, 1100 as s2, 700 as s3, 600 as s4
GO
.setResultSettings 'Index=1,
       CategoryFields="[category]",
       SeriesFields="[s1],[s2],[s3],[s4]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{column,column,column,column}",
       RotX=337,
       RotY=-42,
       RotZ=0,
       ZoomScalar=0.92487824,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="3D Oblique Bar 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=0.25,
       CategorySpacing=0.25,
       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=-5.7999682,
       PanY=-0.09999828,
       Lighting=Default,
       Opacity=.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="Cube,Cube,Cube,Cube",
       SeriesMin="default,default,default,default",
       SeriesMax="default,default,default,default",
       SeriesColor="#008080,#808000,#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'