Reportnet Report Studio Sorting

[koolwinner]

Hello All,

I have a columns in cross tab report developed in reportstudio.

Report looks like this:
_____________________________________________________

Column - > 1-5 6-10 11-15 16-20 21-25 ....
Rows:
Year: 2001 6 0 1 3 5 ....
2002 99 1 ....
2003 .......
.
.
.
_____________________________________________________

Now Q is, i want to sort the display based on column, what kind of expression shud i write to display the columns in above order? (data value in database is as displayed above)

When i use sort function on column it gives me staggered display...as it takes first value 1-5 then shows 11-15..then 21-25....

Can any body help me with this...
Thanks in advance.

Best regards,
nonio

 

[jo0001]

Hi Nonio,

just add a new dataitem as sortKey to your query and type in an expression like the following one:

if(column 1-5) then (1)
else if (column 6-10) then (2) ....

else (0)

Then sort on this sortKey!

Hope this helps!! Jochen