ReportControl: Formated Item Value

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   How can I retrieve the formatted text for a ReportRecordItem?
In the ReportSample project, which has a formated date column, I cannot seem to get out the formatted date string using item.caption, item.Value or item.format
any ideas

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ianp Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 19 December 2003 Location: United Kingdom Status: Offline Points: 119	Post Options Post Reply Quote ianp Report Post Thanks(0) Quote Reply Topic: ReportControl: Formated Item Value Posted: 14 April 2005 at 4:05am
	How can I retrieve the formatted text for a ReportRecordItem? In the ReportSample project, which has a formated date column, I cannot seem to get out the formatted date string using item.caption, item.Value or item.format any ideas

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 15 April 2005 at 7:52am
	if you need only datevalue, you can use VB functions. (Format)
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS

ianp Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 19 December 2003 Location: United Kingdom Status: Offline Points: 119	Post Options Post Reply Quote ianp Report Post Thanks(0) Quote Reply Posted: 15 April 2005 at 3:53pm
	I'd like to be able to access the visible value for all items displayed in the control regardless of type. For date values, how can I convert the ReportCOntrolItem.Format string into a VB method?

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 19 April 2005 at 8:11am
	I mean you can use FormatDateTime VB function FormatDateTime(Item.Value, vbShortDate) FormatDateTime(Item.Value, vbGeneralDate)
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS

ianp Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 19 December 2003 Location: United Kingdom Status: Offline Points: 119	Post Options Post Reply Quote ianp Report Post Thanks(0) Quote Reply Posted: 19 April 2005 at 2:53pm
	sorry oleg, I did understand which functions you meant, but using these functions means I have to compromise my solution by formating the item.value using the closest vb alternative to that used/displayed by the control. What I'd like to do is display/use the exact same formatted value the user sees in the ReportControl. So if one date item is formatted ddd dd/mm/yyyy and another is formatted yyyy-mm-dd, I am able to display the date (item.value) in the correctly formatted way so as not to confuse the end user. Is this possible, or can it be added in future?