Charts Column Sort order
Posted: Mon May 18, 2009 9:24 am
Hi
I am Creating a chart which uses 3 Underlying Tables
ColumnHeadders (ColumnID, ColumnName)
RowHeadders(RowID, RowName)
Quantities(RowID, ColumnID, Value)
And defined the relation ships accordingly
Now I created a Chart with Auto Series Key Data Column Set to Quantities.Relation4.RowID
Auto Series Title Data Column Set to Quantities.Relation4.RowName
Argument Data Column is set to Quantities.Relation3.ColumnName
Value Data Column is set to Quantities.Value
And The chart seem to come up with the Right Series, Columns and Value.
But the problem I am facing is that Column Values are always sorted alphabatically. And This is not what I want; The columns should not be orderd or Orderd by the ColumnID.
Please Help
I am using Version 1 (2008.1.228.0) of simulsoft
I am Creating a chart which uses 3 Underlying Tables
ColumnHeadders (ColumnID, ColumnName)
RowHeadders(RowID, RowName)
Quantities(RowID, ColumnID, Value)
And defined the relation ships accordingly
Now I created a Chart with Auto Series Key Data Column Set to Quantities.Relation4.RowID
Auto Series Title Data Column Set to Quantities.Relation4.RowName
Argument Data Column is set to Quantities.Relation3.ColumnName
Value Data Column is set to Quantities.Value
And The chart seem to come up with the Right Series, Columns and Value.
But the problem I am facing is that Column Values are always sorted alphabatically. And This is not what I want; The columns should not be orderd or Orderd by the ColumnID.
Please Help
I am using Version 1 (2008.1.228.0) of simulsoft