Sorting fields

[realnull]

How to sort fields using iReport ? i know there is a tag <sortfields/> which i manually add in jrxml files , but i'm wondering can i do it directly from iReport ?

[jmurray]

There's a "Sort Options..." button at the bottom of the Report Query dialog box. It injects the Sortfield elements into your xml for you.

 

 

Be careful though: any sorting specified within the source query will override Sortfield specifications.

[Case1182]

at the end of your SQL add this

 

Code:

ORDER BY
YOURTABLE.YOURCOLUMN ASC

 

ASC for Ascending DESC for Descending, if using multiple sorts it is like this.

 

Code:

[code]ORDER BY YOURTABLEFIRSTSORT.YOURCOLUMNFIRSTSORT ASC, YOURTABLESECONDSORT.YOURCOLUMNSECONDSORT DESC, YOURTABLETHIRDSORT.YOURCOLUMNTHIRDSORT ASC

 

you can keep going as long as you like, just seperate with commas and no comma on last entry

 

:)