I am using SAP Crystal Reports Version 2011

[42078560]

I am using SAP Crystal Reports Version 2011 to run data reports from another database. The problem I have is all data TIME fields are recorded as TEXT fields. Crystal will not summarise the text fields, I need the summery to be in time not text, is there a way to convert the TEXT data in to TIME in the report. I have tried to export the data to excel then convert the TEXT to TIME however it is not straight forward, and I need the report to host the data in TIME format.

[former_member11696]

Also note CR 2011 is end of life, time to upgrade:

https://wiki.scn.sap.com/wiki/display/BOBJ/SAP+Crystal+Products+-+End+of+Mainstream+Maintenance+Date...

https://www.sap.com/products/technology-platform/crystal-reports.html

[ido_millet]

See online help for the CTime() function:

CTime (string)

Returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.

Also, the data type may be fixed using a different connectivity method or driver.