Skrypt SQL wykresu liniowego 3-W z liniami zerowymi XY
-------------------------------------------------------------------------------------------------------------------------------------------------------------
--
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'
|
