Topic: Link between tablss in crystal report 2008 Posted: 07 May 2013 at 9:25pm
Hi to all ,
first of all i'm really sorry because of my awful English .
When I export dataset to a report, on the Links tab of the Database Expert, the tables are automatically linked on several fields. i want to display just 2 field from different type of tables I give a error , and when i clear the links the error remove. I'm trying to figure out but I can not ,I check all of links and everything is OK ,I did it in version 8 and it was worked perfectly .
Any help would be greatly appreciated.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 13 May 2013 at 5:26am
The links between tables have to have the same data type. The only way I have heard to get around this (depending on your database) is to create a command and do a data conversion on one of the fields for the link (i.e., INNER JOIN sometable on CAST(somefield as INT) = anotherfield). I have never tried this (never needed to).
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