Dynamic Sorting

ngocvdoan

Hi,

One of my report's requirement is to sort some columns dynamically and I know how to do this in BIRT using the Sorting tab from the dataset. But, how can I sort two different columns in BIRT one in Ascending and the other in Descending at the same time ?

For example: if (params["SortBy"].value = "Both")

{
sort by date asc
sort by amount desc

}

Can we do this in BIRT? Would you please give me some insight?

PS: I know that we can do this through SQL but can this be accomplished inside BIRT?

Thanks,
Steve

kclark

So you're wanting to show a table like this?<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
1 C

2 B

3 A</pre>
<br />
If that's the case you'd need to create two tables in a grid side by side. Then you could sort the first one ascending and the other descending.