Interactive sort has probs

Hi All,

I've designed a simple sales report , first grouped by Transport type and then by item.

Example

Category Item Sales

DHL A 2000

DHL C 1500

DHL E -1700

AmEx A 200

Amex E 20

-

when click on sales under group DHL it shouild sort -say descending-

so result should be

DHL A 2000

DHL C 1500

DHL E -1700

instead I get results

DHL A 2000

DHL E -1700

DHL C 1500

this is just an example but this is the sort of results I get when I try to use interactive sorting.

Any Ideas?

thanks

Sonny

Are you by any chance sorting on the Absolute value of the field? If so, it could be possible that the negative sign is being ignored and 1700 is being used to sort upon, instead of -1700.

Just a thought

-Aayush.

|||

thanks fo rthe reply Aayush. This could be the reason but why would it happen?

sonny

|||What Sort expression have you given under the Interactive Sort option for your textbox? Are you passing the field value as it is, or using some function there?|||

I'm not using any functions. Just passing the value as it is.

thanks'

Sonny

|||factoid:
did you know you can sort multiple cols in IE by holding down Shift when clicking on the little sort uppy downy jobbies?