Ordering by a string field

rbuser

When Ordering my report by a string field, the resultant report displays
only those records where that field is null. If I remove this 'order by'
then the report displays all records.
Any reason why an order by would remove records from a report?


Thanks in Advance.

Regards,

Nick White

rbuser

Hi Nick,

the ordering is done by the database. AFAIK, a 'ORDER BY' clause shouldn't exclude NULL values.
When the column is used in the 'WHERE' clause then you have to include NULL values explicitely.
Did the generated SQL expression looked as expected?

regards,
Chris Ueberall;