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?
I have select permissions on my tables, and I do it.
You'll have to try it to know for sure. It only takes a minute.
Now, it's not going to override a join in your sql...it adds to it.