Skip to Content
Jul 20, 2020 at 02:16 PM

Crystal Reports 10 - Linking tables through fields with different data types

259 Views Last edit Sep 03, 2020 at 12:29 PM 2 rev

I am using Crystal Reports 10 with an Access Database. I want to link two tables though fields that have different data types. One is number and other is text.

One way is to have a sub-report. However, that makes the main report run very slow.

I got to know another way is to have add SQL Query to convert data types and link the tables. I am not familiar with SQL. Can anyone please assist.