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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
LEFT JOIN on different data types CR10
I have tried both an ODBC as well as an ADO/OLE DB connection to DB2 and then running the query as a command. Crystal does not recognize the "DECIMAL" function. I have tried using ToNumber, Cstr etc to convert either of the fields to the other type, but nothing works. Any other suggestion...- KTTapee
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
LEFT JOIN on different data types CR10
I have 2 DB2 tables that I need to join on fields that are different data types, one is a string, the other a number. When I use a DB2 query tool, I can use the funtion "DECIMAL" to make the join work. In Crystal, I have tried many functions to get the join to work, without success. Here is...- KTTapee
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
