Report Control - Sorting on NULL-Values

Print Page | Close Window

Sorting on NULL-Values

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=2813
Printed Date: 26 April 2024 at 5:41pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Sorting on NULL-Values

Posted By: jamesblast
Subject: Sorting on NULL-Values
Date Posted: 30 August 2005 at 4:04am

hello,

I fill my reportcontrol with some data from a accesstable.
in this table some cols are NULL, but the column is a date-type.

the reportcontrol gets the right display, even with Null-Values, but if i want to sort the mixed "date or null" column i get really strange results. it moves something, but i dont see any good sorting (it could be in order like null,null,date,null,date,date,date,null....)

what did i miss? what do i have to know about nullvalues in report-control?

thank you