Link between tablss in crystal report 2008
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19515
Printed Date: 19 Apr 2024 at 5:03am
Topic: Link between tablss in crystal report 2008
Posted By: nahalrazeghi
Subject: Link between tablss in crystal report 2008
Date 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.
please help me .
Thank you.
-------------
Nahal
|
Replies:
Posted By: nahalrazeghi
Date Posted: 10 May 2013 at 7:10pm
please help me ....
-------------
Nahal
|
Posted By: kevlray
Date 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).
|
|