1

...and that is exactly the opposite of what I want. What I'd like to see is have the records with a date shown first, at the top of the datagrid, sorted in descending order, followed by the records that don't have the date filled. Is there a way to have the datagrid sorted as I described here? [Updated] Did some research on this subject. Apparently this sorting behavior is the default behavior in practically every database. Oracle and Postgres have a very easy way to extend the ORDER BY clause to sort NULL values last. In Microsoft SQL Server you need a little hack to get it working. Some links for your reading pleasure: Oracle Control null data in Oracle using the ORDER BY clause - http://www.techrepublic.com/blog/datacenter/control-null-data-in-oracle-using-the-order-by-clause/121 Postgres PostgreSQL Documentation - Sorting Rows - http://sqlservercode.blogspot.com/2007/10/sort-values-ascending-but-nulls-last.html Microsoft SQL Server Sort Values Ascending But NULLS Last - http://sqlservercode.blogspot.com/2007/10/sort-values-ascending-but-nulls-last.html Final thoughts: I think it would be very nice if there was a setting available in the Sort Attributes dialog to set the sort order for NULL values. The current workaround would be to avoid NULL values in the sorted column by setting default values. Sometimes this is not what I want because these default values can be confusing to users and do not make any sense.

asked 2012-03-21

2 answers