2D Scatter Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2D Scatter 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, 25 as s1, 70 as s2
union
select 2 as category, 18 as s1, 73 as s2
union
select 3 as category, 20 as s1, 80 as s2
union
select 4 as category, 40 as s1, 70 as s2
union
select 5 as category, 50 as s1, 65 as s2
union
select 6 as category, 47 as s1, 60 as s2
union
select 7 as category, 55 as s1, 65 as s2
union
select 8 as category, 60 as s1, 55 as s2
union
select 9 as category, 65 as s1, 47 as s2
union
select 10 as category, 70 as s1, 43 as s2
GO
.setResultSettings 'Index=1,
       CategoryFields="[category] ASC",
       SeriesFields="[s1],[s2]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{scatter,scatter}",
       RotX=324,
       RotY=0,
       RotZ=0,
       ZoomScalar=1.2029626,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="2D Scatter 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=6.0,
       SeriesSpacing=1.0,
       CategorySpacing=1.0,
       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=-289.9,
       PanY=-157.7,
       Lighting=Bright,
       Opacity=1.0,
       View2D=true,
       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",
       SeriesSubType=",",
       SeriesColumnType="Cube,Cube",
       SeriesMin="default,default",
       SeriesMax="default,default",
       SeriesColor="#3366ff,#ff0000",
       SeriesFunctionMetaData="true,true",
       ShowSeriesDataLabels="false,false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=true,
       FixedCategoryCount=0'