I am working on a report in crystal 9 from a vendor database with timestamp fields, and I am having problems with the data types converting to a picture as the data type where there are time fields in the tables I am selecting from.

 

When I actually try to  input the field in the crystal report the field changes to  a “BLOB” file and when I go to the database expert to view the links of the tables the time fields are not there they are eliminated from the selection/browse in the tables.

 

Any clues of how or what to do?  I’m not too good with SQL, but someone suggested trying this as an option.