Codejock Developer Community : Sort/Group problem with null-value rows http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 21:07:27 +0000 Wed, 16 Mar 2011 05:56:03 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=18025 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sort/Group problem with null-value rows : Hi, Manually setting the values...]]> http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63339&title=sort-group-problem-with-nullvalue-rows#63339 Author: karlvhan
Subject: 18025
Posted: 16 March 2011 at 5:56am

Hi,

Manually setting the values of SortPriority and GroupPriority to 0 whenever we encounter an item where the value is null, seems to solve the problem.

Thanks Smile
]]> Wed, 16 Mar 2011 05:56:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63339&title=sort-group-problem-with-nullvalue-rows#63339 <![CDATA[Sort/Group problem with null-value rows : Hi, don&#039;t know if this is...]]> http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63327&title=sort-group-problem-with-nullvalue-rows#63327 Author: Peter59
Subject: 18025
Posted: 15 March 2011 at 5:14pm

Hi,

don't know if this is normal behaviour of ReportControl but you can use SortPriority and GroupPriority to enforce correct sorting/grouping - see attached sample. uploads/3156/Grouping_NULL_values.zip

The sample assumes a simple booking list by a hotel: some arrival dates are not confirmed (NULL) and some room categories are NULL. Providing SortPriority/GroupPriority manually you can achieve expected sorting/grouping.

Peter
 
]]> Tue, 15 Mar 2011 17:14:11 +0000 http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63327&title=sort-group-problem-with-nullvalue-rows#63327 <![CDATA[Sort/Group problem with null-value rows : Hi, Can you upload a test project...]]> http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63322&title=sort-group-problem-with-nullvalue-rows#63322 Author: Aaron
Subject: 18025
Posted: 15 March 2011 at 8:40am

Hi,

Can you upload a test project where the above is showing?

Thanks

 

]]> Tue, 15 Mar 2011 08:40:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63322&title=sort-group-problem-with-nullvalue-rows#63322 <![CDATA[Sort/Group problem with null-value rows : Hi, If one or more rows are missing...]]> http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63198&title=sort-group-problem-with-nullvalue-rows#63198 Author: karlvhan
Subject: 18025
Posted: 09 March 2011 at 11:13am

Hi,

If one or more rows are missing data in a column, sorting and grouping on this column won't work properly.

In the printscreen below, I have attempted to sort the contents of the ReportControl by clicking on the column header for the column labeled "String". It seems that the ReportControl isn't able to properly distinguish between rows that actually do have a value and rows that don't (i.e. the value is null). Instead, it mixes these together, resulting in a list where the rows are incorrectly sorted.


The next printscreen shows that grouping on a column which contains both ordinary values and null-values can result in multiple groups with identical criteria. (In this example, we have two groups where both groups are defined by having the value null in the column "String". (This can also happen to other values than null.))


Is this a known problem with the ReportControl?
Or is there a way to make ReportControl handle such null-value rows? (Preferrably without having to go through each combination of column and row in order to replace the value where such a null-value occurs...)


]]> Wed, 09 Mar 2011 11:13:36 +0000 http://forum.codejock.com/forum_posts.asp?TID=18025&PID=63198&title=sort-group-problem-with-nullvalue-rows#63198