Print Page | Close Window

Date/Time Field appears blank Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6245 Printed Date: 04 May 2024 at 4:55am Topic: Date/Time Field appears blank Posted By: leedo2k Subject: Date/Time Field appears blank Date Posted: 04 May 2009 at 3:54am Hi, I have a wierd problem in my vs 2005 report. I am connecting to a CSV file listing rows including a field with date time. It appears that this date/time field sometimes for some reason doesn't appear in the report. I opened the CSV file itself to inspect the date time values and found out that sometimes this filed contains the split second value and sometimes it doesn't. E.g (3/3/2009 11:39) and some other times it is like(29/03/2009 14:03:22) I tried converting the field into string using the "STR" function in a formula, and even used SQL expression to force it to display as string but still it shows as blank. [IMG]smileys/smiley5.gif" align="middle" /> Please help.. Thx

Print Page | Close Window