Problem with ascending sorting

BlueInTheSky

Hello,

I have the following little Problem:
I want to sort ascending after a special field. There are a lot of records where there is nothing in that field so when I sort ascending after that field, there will be the records, where there is nothing in taht field first. And exacly that is what I do not want. I want to sort ascending but with the records at the end, where there is nothing in that field.
Does anybody have an idea how to solve that problem? Is there a property with what you can manage how empty fields are treated at sorting? Or are they always first when sorting ascending?

Thank you in advance,

Blue

matttrax

I'm pretty sure it always sorts like this. There might be some kind of special sorting if you're using SQL, but I'm not positive.

If you are sorting the data for a report you can just have 2 data items. The first executes where the field is not blank, the second when it is.