Sorting inside group

MBrison

Hi,

Creating a Birt 2.1.2 report for Maximo 7. I need to group by Crafts then sort by wonums/task inside that group.

Everything works fine in my environments (eclipse and Maximo). Added wonum and taskid on the "Sort" tab of the table.

But, when the client runs the report in his Maximo, the sorting inside the group is all messed up.

Any advice?!?!

Thanks.

- Marc

SpaceMan

Try using order by inside your SQL statement on the Open event of your data set:

select...
from workorder...
order by wonum, taskid

Hope that helps