Version: 13.0-alpha-4

Build #: 30585

Build Date: 2012-Dec-12 09:25:17 AM

 

Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10

Memory: Max=891,092,992;  Total=332,857,344;  Free=64,828,312;  CPUs=8

 

In-Window Graphics Capabilities

Graphics Vendor: NVIDIA Corporation

OpenGL Renderer: Quadro FX 1700/PCI/SSE2

OpenGL Version: 3.3.0

Double-Buffering: Enabled

Anti-Aliasing: Enabled

Anti-Aliasing Sample Count: 16

Hardware Acceleration: Enabled

Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 0

Depth Bits: 24

Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16

Initialization Time: 1093 ms

 

 

Offscreen Graphics Capabilities

Graphics Vendor: Brian Paul

OpenGL Renderer: Mesa OffScreen

OpenGL Version: 2.1 Mesa 7.8.2

Double-Buffering: Disabled

Anti-Aliasing: Disabled

Anti-Aliasing Sample Count: 0

Hardware Acceleration: Disabled

Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 8

Depth Bits: 16

Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16

Initialization Time: 15 ms

Hardware PBuffer Available: No

Using PBuffer: No

Using Ram Buffer: Yes

Offscreen Rendering: Enabled

Offscreen Buffer Size: 800x600

 

 

 

1. execute the chart below.

2. notice that the text on the left of the chart is black, but the horizontal lines in the chart do match the series color

 

see attached screenshot.

 

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Bar-Area Combination 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, 75 as s1, 35 as s2
union
select 2 as category, 45 as s1, 55 as s2
union
select 3 as category, 55 as s1, 90 as s2
union
select 4 as category, 45 as s1, 45 as s2
union
select 5 as category, 65 as s1, 85 as s2
union
select 6 as category, 40 as s1, 60 as s2
union
select 7 as category, 80 as s1, 35 as s2
union
select 8 as category, 45 as s1, 55 as s2
union
select 9 as category, 45 as s1, 90 as s2
union
select 10 as category, 20 as s1, 45 as s2
GO
.setResultSettings 'Index=1,
       CategoryFields="[category]",
       SeriesFields="[s2],[s1]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{column,area}",
       RotX=314,
       RotY=-26,
       RotZ=0,
       ZoomScalar=1.3588234,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="3D Bar Area Combination 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=4.0,
       SeriesSpacing=0.45,
       CategorySpacing=0.45,
       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=-7.6999955,
       PanY=-4.099999,
       Lighting=Default,
       Opacity=0.8,
       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=false,
       SeriesAlias="default,default",
       SeriesSubType=",",
       SeriesColumnType="Cube,Cube",
       SeriesMin="default,default",
       SeriesMax="default,default",
       SeriesColor="#993300,#3366ff",
       SeriesFunctionMetaData="true,true",
       ShowSeriesDataLabels="false,false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=false,
       FixedCategoryCount=1'