3D Thin Column Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Thin Column 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, 2000 as s1, 1500 as s2, 750 as s3, 500 as s4
union
select 2 as category, 2500 as s1, 1750 as s2, 1250 as s3, 750 as s4
union
select 3 as category, 2750 as s1, 1500 as s2, 1200 as s3, 600 as s4
union
select 4 as category, 3000 as s1, 1700 as s2, 1500 as s3, 700 as s4
union
select 5 as category, 3250 as s1, 1700 as s2, 900 as s3, 300 as s4
union
select 6 as category, 3500 as s1, 2000 as s2, 1300 as s3, 500 as s4
union
select 7 as category, 4000 as s1, 1500 as s2, 1000 as s3, 750 as s4
GO
.setResultSettings 'Index=1,
     CategoryFields="[category] ASC",
     SeriesFields="[s1],[s2],[s3],[s4]",
     ShowChart=true,
     ShowToolbar=true,
     Paging=true,
     Split=300,
     Chart="{column,column,column,column}",
     RotX=325,
     RotY=-25,
     RotZ=0,
     Zoom=23.606081,
     ScaleData=true,
     ShowLegend=true,
     ShowGrid=true,
     Title="3D Thin Column Chart",
     PieExplode=0.0,
     GroupSmallValues=true,
     SmallValuesThreshold=3.0,
     PieLabelDistance=3.0,
     PieShowLines=false,
     LineWidth=1.0,
     Width=16.0,
     Height=10.0,
     Depth=8.0,
     SeriesSpacing=5.0,
     CategorySpacing=5.0,
     Font="Arial-6",
     TopColor="#D7DCF5",
     BottomColor="#EBF0F5",
     PanX=-6.600001,
     PanY=-2.6999984,
     Lighting=Default,
     View2D=false,
     StackedPercent=true,
     ShowValueAxis=true,
     ShowCategoryAxis=true,
     ShowSeriesAxis=false,
     ValueAxisNumberFormat="###0",
     CategoryAxisNumberFormat="#,##0",
     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",
     LegendPosition=Top Right,
     LegendWidthType=Exact,
     LegendWidth=100,
     LegendHeightType=Fit,
     LegendHeight=160,
     ShowFixedCategoryCount=true,
     FixedCategoryCount=0'