Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
829
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Surface
--
-- 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, 45 as s2
union
select 2 as category, 10 as s1, -25 as s2
union
select 3 as category, 40 as s1, -5 as s2
union
select 4 as category, 70 as s1, 15 as s2
union
select 5 as category, 65 as s1, 50 as s2
union
select 6 as category, 40 as s1, -25 as s2
union
select 7 as category, 33 as s1, 23 as s2
union
select 8 as category, 95 as s1, 4 as s2
union
select 9 as category, 10 as s1, 12 as s2
union
select 10 as category, 70 as s1, 55 as s2
GO
.setResultSettings 'Index=1,
CategoryFields="[category] ASC",
SeriesFields="[s1],[s2]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=300,
Chart="{surface,surface}",
RotX=317,
RotY=-4,
RotZ=0,
Zoom=17.606081,
ScaleData=true,
ShowLegend=true,
ShowGrid=true,
Title="3D Surface Chart",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
Width=16.0,
Height=10.0,
Depth=5.5,
SeriesSpacing=1.0,
CategorySpacing=1.0,
Font="Arial-6",
TopColor="#D7DCF5",
BottomColor="#EBF0F5",
PanX=-8.600001,
PanY=-3.7000015,
Lighting=Bright,
View2D=false,
StackedPercent=false,
ShowValueAxis=true,
ShowCategoryAxis=true,
ShowSeriesAxis=false,
ValueAxisNumberFormat="###0",
CategoryAxisNumberFormat="#,##0",
NumericCategoryAxis=false,
MergeAxis=true,
SeriesAlias="default,default",
SeriesSubType=",",
SeriesColumnType="Cube,Cube",
SeriesMin="default,default",
SeriesMax="default,default",
SeriesColor="#3366FF,#993300",
SeriesFunctionMetaData="true,true",
LegendPosition=Top Right,
LegendWidthType=Exact,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=true,
FixedCategoryCount=0'
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017