× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2009-03-17T00:40:43Z  · last modified 2009-03-23T16:56:31Z

Charts -- negative values for merge series


Dev mattbrumley(*)
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Charts
Version 07.5

SQL Server 2000 Northwind Database

if you execute the below query and then in Chart Properties in Axes

tick Merge Series axis. the chart displays negative values, which is incorrect....See attached pic

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=300,
    Chart="{column,area}",
    RotX=317,
    RotY=1,
    RotZ=0,
    Zoom=20.606081,
    ScaleData=true,
    ShowLegend=true,
    ShowGrid=true,
    Title="3D Bar Area Combination Chart",
    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=0.45,
    CategorySpacing=0.45,
    Font="Arial-6",
    TopColor="#D7DCF5",
    BottomColor="#EBF0F5",
    PanX=-8.0,
    PanY=-5.0,
    Lighting=Default,
    View2D=false,
    StackedPercent=false,
    ShowValueAxis=true,
    ShowCategoryAxis=true,
    ShowSeriesAxis=false,
    ValueAxisNumberFormat="###0",
    CategoryAxisNumberFormat="#,##0",
    NumericCategoryAxis=true,
    MergeAxis=false,
    SeriesAlias="default,default",
    SeriesSubType=",",
    SeriesColumnType="Cube,Cube",
    SeriesMin="default,default",
    SeriesMax="default,default",
    SeriesColor="#FF0000,#333399",
    SeriesFunctionMetaData="true,true",
    LegendPosition=Top Right,
    LegendWidthType=Exact,
    LegendWidth=100,
    LegendHeightType=Fit,
    LegendHeight=160,
    ShowFixedCategoryCount=false,
    FixedCategoryCount=1'

1 attachment

Issue #2431

Closed
Fixed
Resolved 2009-03-23T16:56:31Z
 
 
Completion
No due date
No fixed build
No time estimate

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