sorting and ordering

I am working on a cross tab report:

I have the information populating however I can not get it to sort correctly for the month:

I am using timestamp dateparts month, however the dates are not in order.

I tried putting in the order by expression but the report compiles with an error.

How do I sort the return data in a cross tab report

Portlight's picture
Joined: Jan 6 2011 - 9:11am
Last seen: 8 years 9 months ago

1 Answer:

the only way I know to sort data in iReport is through the query itself, put an order by clause in your query
lknueve's picture
Joined: Jan 10 2011 - 3:00pm
Last seen: 12 years 8 months ago