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
825
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Pie 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 'A' as category, 40 as s1
union
select 'B' as category, 55 as s1
union
select 'C' as category, 3 as s1
union
select 'D' as category, 45 as s1
union
select 'E' as category, 15 as s1
GO
.setResultSettings 'Index=1,
CategoryFields="[category]",
SeriesFields="[s1]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=0,
Chart="{pie}",
RotX=306,
RotY=0,
RotZ=0,
ZoomScalar=1.1038268,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridLineWidth=1.0,
Title="3D Pie Chart",
TitlePosition="Bottom Center",
TitleCategory="",
TitleValue="",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=4.0,
PieShowLines=false,
LineWidth=1.0,
ShowMarkers=true,
MapShowBackground=false,
MapShowDetails=false,
MapRange="",
MapRangeColors="",
Width=16.0,
Height=10.0,
Depth=12.0,
SeriesSpacing=0.5,
CategorySpacing=0.5,
Font=Arial-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=-60.9,
PanY=336.0,
Lighting=Bright,
Opacity=1.0,
View2D=false,
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",
SeriesSubType="",
SeriesColumnType="Cube",
SeriesMin="default",
SeriesMax="default",
SeriesColor="#333333",
SeriesFunctionMetaData="true",
ShowSeriesDataLabels="false",
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