Sorting data in a Jazz Data Set for a BIRT report..

Is there a away to sort data in a jazz dataset before a BIRT report is built from that data set. For Example: I would like to see the returned data set sorted by a Date/timestamp.
If this is not possible in the current version of RTC/Jazz can this feature be included in a future version?
Thanks in advance... O. Frank

Hey Frank - you can sort in bits by using this script on your datasets beforeOpen script:
queryString = this.queryText;
queryString = queryString +
" order by " +

reportContext.getParameterValue("WI_ID") +
" " +
reportContext.getParameterValue("asc");
this.queryText = queryString ;

or you can click the table in your layout and then click the sorting tab in the properties editor to sort the final result.

I tried to modify this.queryText, but it seems do not affect the report what so ever.

Is there a away to sort data in a jazz dataset before a BIRT report is built from that data set. For Example: I would like to see the returned data set sorted by a Date/timestamp.
If this is not possible in the current version of RTC/Jazz can this feature be included in a future version?
Thanks in advance... O. Frank

Hey Frank - you can sort in bits by using this script on your datasets beforeOpen script:
queryString = this.queryText;
queryString = queryString +
" order by " +

reportContext.getParameterValue("WI_ID") +
" " +
reportContext.getParameterValue("asc");
this.queryText = queryString ;

or you can click the table in your layout and then click the sorting tab in the properties editor to sort the final result.

The Jazz Data Source does not support sorting. You would have to do the sort the data after fetching it.

The solution proposed above may only work for a JDBC Data Source that uses SQL.