title: Linking failed due to missmatched data types
body: <p>I am trying to create a report in Crystal Reports 2013 using an Oracle database. At issue is two tables.fields same data different data types.  This is causing the linking to fail. work.job is char(50 byte) while job.id is varchar2 (3 byte), I want to link these two fields so I can pull the job.desc onto the report. I don't have access the database to create views or stored procedures, and even if I it would be local and could not be delivered to the client. I thought I could use the Add Command function in Database Expert but I'm not sure how to use it?  Any suggestions would be very helpful.</p>