I've got a sql statement that select
data and creates a label using case statements. I use the label as
the X axis on a chart but I use the ORDERBY clause in the sql statement
from the database. When I view is in preview mode the data is properly
sorted, but when put in a chart BIRT messes up the order of the data so
that a few of the values get pulled out of order and put at the backend
of the chart. Ex. in order it would do 7am,9am,10am... 5pm,6pm,7pm,8am,11am.
Any ideas how to fix this.