Visual Basic, Date/Time type in Crystal Reports

Date/Time type in Crystal Reports

Author	Message
Dave Schob #1 / 3	Date/Time type in Crystal Reports I'm new to VB and Crystal Reports, so this may be a stupid question. I'm using Crystal Reports 2.0 for VB and I've run into a bit of a snag. I have a date/time data type that I'm reading from an access 2.0 mdb file. However when I place the field into a report, the only formating options I get are for Date...nothing for time. Any suggestions would be greatly appreciated. Cheers Dave Schober
Mon, 14 Jul 1997 09:52:27 GMT

Simon Clend #2 / 3	Date/Time type in Crystal Reports Quote: > I'm new to VB and Crystal reports, so this may be a stupid question. I'm > using Crystal Reports 2.0 for VB and I've run into a bit of a snag. I have > a date/time data type that I'm reading from an access 2.0 mdb file. However > when I place the field into a report, the only formating options I get are > for > Date...nothing for time. > Any suggestions would be greatly appreciated Hi Dave. Unfortunately Crystal standard v2.0 that comes with VB3.0 cannot "see" the time part of a date/time field unless you read it via ODBC and tweak some ini settings somewhere (I think). If you have control of what goes into the database then try adding a separate field for the time eg an integer containing a 24 hour time. Bit yukky but it gets around the problem. Cheers, Simon (New Zealand)
Tue, 15 Jul 1997 15:47:07 GMT

David M. Stevens #3 / 3	Date/Time type in Crystal Reports Quote: >I'm new to VB and Crystal reports, so this may be a stupid question. I'm >using Crystal Reports 2.0 for VB and I've run into a bit of a snag. I have >a date/time data type that I'm reading from an access 2.0 mdb file. However >when I place the field into a report, the only formating options I get are for >Date...nothing for time. The easiest solution is to convert the time field to a string and save it as a "text field" in the databank. Crystal reports will make the "string" look like a time field. Any calculations must be made in VB with the re-converted string. David -- _________________________________________________________________ Tulbeckstr. 23 CIS: 100042,1312 Hope of Eternity! 80339 Munich, Germany Tel +49-89-5024668 ! != ?
Fri, 18 Jul 1997 01:25:12 GMT

Page 1 of 1

[ 3 post ]