on 11-30-2007 12:46 PM
Post Author: bbazian
CA Forum: General
I have a MySQL database with a date and a time field. The date field reports correctly in CRXI but I am unable to get the time field to work. Is there something I need to know on how to format this? I know the data is correct in the database as HH:MM:SS but CR reports it as 12:00:00 am for all records.
Post Author: bbazian
CA Forum: General
I did a work around. Changed the MySQL field to a char field and then parsed it and converted it to a time field in the report.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Post Author: Jagan
CA Forum: General
In the field browser, does Crystal report the field as being a Date or a DateTime?
Crystal did this to me once too, and I seem to remember finding a 'Convert datetime to date' box that was ticked somewhere in the Options or Report Options menu item.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.