http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 12:12:11 +0000 Thu, 16 Apr 2009 09:53:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14034 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=14034&PID=48012&title=display-value-different-from-underlying-value#48012 Author: jpbro
Subject: 14034
Posted: 16 April 2009 at 9:53am

Thanks Marco. That's useful information (that the Value property can be separate from the Caption property, and I assume the ReportControl sorts on the Value property). The reason I am now using the BeforeDrawRow event is because I am working with the ReportControl in VirtualMode (since I haven't been able to get Bound mode to work with my SQLite database provider yet). ]]> Thu, 16 Apr 2009 09:53:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=48012&title=display-value-different-from-underlying-value#48012 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=47985&title=display-value-different-from-underlying-value#47985 Author: MNovaro
Subject: 14034
Posted: 16 April 2009 at 3:16am

Wouldn't be easier to set the .Caption of the record Item when you populate the report:

Item.Value = 2009-04-15T20:07Z
Item.Captin = "Today at 3PM"

HTH
]]> Thu, 16 Apr 2009 03:16:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=47985&title=display-value-different-from-underlying-value#47985 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=47969&title=display-value-different-from-underlying-value#47969 Author: jpbro
Subject: 14034
Posted: 15 April 2009 at 11:07pm

Okay, I think I have figured out how to do this with BeforeDrawRow event custom handling of the Metrics object. I will post a sample at some point if all goes well.

]]> Wed, 15 Apr 2009 23:07:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=47969&title=display-value-different-from-underlying-value#47969 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=47968&title=display-value-different-from-underlying-value#47968 Author: jpbro
Subject: 14034
Posted: 15 April 2009 at 7:56pm

Is it possible to have display values that are different from the underlying values in a cell?

For example, if I have a Date column, I might store the underlying data in ISO8601 format, but then I would like to display friendly names for certains dates (i.e. the underlying data for today would be  2009-04-15T20:07Z, but I would like the ReportControl cell to show "Today at 3PM" (time adjusted for time zone)).  Older dates might show "Yesterday" or "Last Week", etc... instead of the full date. However, because the underlying data stores actual database values, sorting and searching would take place on those values instead of on the displayed (cosmetic only) values.

Is this possible with the ReportControl currently?
]]> Wed, 15 Apr 2009 19:56:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=14034&PID=47968&title=display-value-different-from-underlying-value#47968