Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Thank you

Former Member
Former Member replied

Reid,

Yes.

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question