Joined: 21 May 2007
Online Status: Offline
Posts: 16
Topic: Data Types are not compatible Posted: 18 Sep 2007 at 12:03pm
I'm trying to link fields from two different data sources. Once field is a string and the other is a number field. I'm getting an error message stating "Data Types are not compatible". Is there another way to link these two fields?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 18 Sep 2007 at 12:39pm
Use a formula to convert the number to a string (or vice-versa) and then use that formula as the linking field. Remember to format it properly so that the values match exactly (trailing decimal places will cause problems if you don't account for them).
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
