× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2012-12-12T19:06:45Z  · last modified 2012-12-18T22:53:15Z

how do I get alternating row colors in the "Show Grid" like ADStudio v12?


Dev mattbrumley(*)
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component App - Charts
Version 13.0

 

 

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=311,296,000;  Free=117,515,280;  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: 609 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: 172 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes

 

Using the script at the bottom of the page, ADStudio v12 allowed me to get alternating row colors in the "Show Grid", if I chose "Merge Series Axes".

In v13, how do I get the alternating Grid row colors?

 

see attached very large screenshot that has both versions visible.

 

 

 

 

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2D Area 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
union
select  2  as  category,  10  as  s1
union
select  3  as  category,  40  as  s1
union
select  4  as  category,  70  as  s1
union
select  5  as  category,  65  as  s1
union
select  6  as  category,  40  as  s1
union
select  7  as  category,  33  as  s1
union
select  8  as  category,  95  as  s1
union
select  9  as  category,  10  as  s1
union
select  10  as  category,  70  as  s1
GO
.setResultSettings 'Index=1,
       CategoryFields="[category] ASC",
       SeriesFields="[s1]",
       ShowChart=true,
       ShowToolbar=true,
       Paging=true,
       Split=0,
       Chart="{area}",
       RotX=324,
       RotY=0,
       RotZ=0,
       ZoomScalar=1.2025924,
       ShowLegend=true,
       ShowLegendBorder=true,
       ShowGrid=true,
       FillGrid=true,
       GridLineWidth=1.0,
       Title="2D Area 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=12.0,
       SeriesSpacing=0.5,
       CategorySpacing=0.5,
       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=-296.09998,
       PanY=-167.3,
       Lighting=Bright,
       Opacity=0.9,
       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",
       SeriesSubType="",
       SeriesColumnType="Cube",
       SeriesMin="default",
       SeriesMax="default",
       SeriesColor="#378793",
       SeriesFunctionMetaData="true",
       ShowSeriesDataLabels="false",
       LegendPosition=Top Right,
       LegendWidthType=Exact,
       LegendWidth=100,
       LegendHeightType=Fit,
       LegendHeight=160,
       ShowFixedCategoryCount=true,
       FixedCategoryCount=0'

1 attachment

Issue #8061

Closed
Fixed
Resolved 2012-12-18T22:19:41Z
 
 
Completion
No due date
Fixed Build 30653
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017