3D XY Line Zero Axis Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D  XY Line 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 0 as category, -1 as s1
union
select 1 as category, -1.25 as s1
union
select -1.25 as category, 1 as s1
union
select -1.50 as category, 2 as s1
union
select -1.75 as category, 0 as s1
union
select 2 as category, -1 as s1
GO
.setResultSettings 'Index=1,
     CategoryFields="[category]",
     SeriesFields="[s1]",
     ShowChart=true,
     ShowToolbar=true,
     Paging=true,
     Split=300,
     Chart="{line}",
     RotX=317,
     RotY=-42,
     RotZ=0,
     Zoom=20.606081,
     ScaleData=true,
     ShowLegend=true,
     ShowGrid=true,
     Title="3D XY Line Zero Axis",
     PieExplode=0.0,
     GroupSmallValues=true,
     SmallValuesThreshold=3.0,
     PieLabelDistance=3.0,
     PieShowLines=false,
     LineWidth=1.0,
     Width=16.0,
     Height=10.0,
     Depth=4.0,
     SeriesSpacing=1.0,
     CategorySpacing=1.0,
     Font="Arial-7",
     TopColor="#EBF0F5",
     BottomColor="#D7DCF5",
     PanX=-7.3000007,
     PanY=-3.1999993,
     Lighting=Default,
     View2D=false,
     StackedPercent=false,
     ShowValueAxis=true,
     ShowCategoryAxis=true,
     ShowSeriesAxis=true,
     NumericCategoryAxis=false,
     MergeAxis=false,
     SeriesAlias="default",
     SeriesSubType="",
     SeriesColumnType="Cube",
     SeriesMin="default",
     SeriesMax="default",
     SeriesColor="#FF0000",
     SeriesFunctionMetaData="true",
     LegendPosition=Top Right,
     LegendWidthType=Fit,
     LegendWidth=100,
     LegendHeightType=Fit,
     LegendHeight=160,
     ShowFixedCategoryCount=false,
     FixedCategoryCount=0'