modnarblue
Programmer
I am using Crystal Reports 4 and cannot display time from my sql database. It has only got a Date field. Is there a way to display time in Crystal Reports 4. I need help. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DATE PROBLEMS!!!
- Thread starter modnarblue
- Start date
- Status
synapsevampire
Programmer
Time may not have been available in CR 4 in fact, that version may predate recorded time 
You might add a column to the SQL Server database to handle this, or the obvious solution is to get a more recent version of CR (assuming that you don't mean a 4.X version).
-k
You might add a column to the SQL Server database to handle this, or the obvious solution is to get a more recent version of CR (assuming that you don't mean a 4.X version).
-k
- Thread starter
- #3
modnarblue
Programmer
Thank you very much. Just thought I was overlooking something in Crystal itself.
I've worked with Crystal since version 6, but make sure that there isn't a report option (or server option) to convert datetime to date. After that is changed (if it exists) remove your date field, reconnect your data source and repaint your date field, It should show date&time. By the way, this is even a problem with newer versions.
PERRY
PERRY
- Status
Similar threads
- Locked
- Question
- Locked
- Question