Codejock Developer Community : Sorting on checkbox columns http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 16 May 2026 00:36:35 +0000 Mon, 12 Feb 2007 15:25:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6380 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sorting on checkbox columns : Yes, you can. However, you&#039;ll...]]> http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20323&title=sorting-on-checkbox-columns#20323 Author: sserge
Subject: 6380
Posted: 12 February 2007 at 3:25pm

Yes, you can. However, you'll have to use another property .SortPriority
Like:

Set Item = Record.AddItem("")
Item.HasCheckbox = True
Item.Checked = CBool(!Doc)
Item.SortPriority = CInt(!Doc)


--
WBR,
Serge
]]> Mon, 12 Feb 2007 15:25:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20323&title=sorting-on-checkbox-columns#20323 <![CDATA[Sorting on checkbox columns : Ok, I figured it out. Just add...]]> http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20322&title=sorting-on-checkbox-columns#20322 Author: jcollier
Subject: 6380
Posted: 12 February 2007 at 3:19pm

Ok, I figured it out.  Just add the following line to the code I listed above.

Item.SortPriority = IIf(CBool(!Doc), 0, 1)
]]> Mon, 12 Feb 2007 15:19:57 +0000 http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20322&title=sorting-on-checkbox-columns#20322 <![CDATA[Sorting on checkbox columns : Funny this just got asked today....]]> http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20319&title=sorting-on-checkbox-columns#20319 Author: jcollier
Subject: 6380
Posted: 12 February 2007 at 3:03pm

Funny this just got asked today.  I also would like to know how to sort on checkbox columns.  The following code checks the box properly but trying to click the column name and sort does not do anything.

Set Item = Record.AddItem("")
Item.HasCheckbox = True
Item.Checked = CBool(!Doc)
]]> Mon, 12 Feb 2007 15:03:43 +0000 http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20319&title=sorting-on-checkbox-columns#20319 <![CDATA[Sorting on checkbox columns : Hi,I&#039;m setting up a report...]]> http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20299&title=sorting-on-checkbox-columns#20299 Author: atarba
Subject: 6380
Posted: 12 February 2007 at 8:19am

Hi,

I'm setting up a report control column to just show checkboxes (for a logical field) but I do not set the value of the item to yes or no because I just want the checkbox in the column.
Is there any way to have sorting on this column without setting the value?

Thanks,
Andrei
]]> Mon, 12 Feb 2007 08:19:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=6380&PID=20299&title=sorting-on-checkbox-columns#20299