Linking Two Fields with Different Data Types
I am attempting to create a report where the SQL I am taking to make the report has a join where one field is equal to another with a cast function. What it is doing is casting the string as an integer. In one table the field is an integer and the other its a string. When I go to link the tables together in Crystal Reports it says that it cannot link the fields because they are two different data types. What options do I have?