Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Beginers question Post Reply Post New Topic
Author Message
andrew
Newbie
Newbie
Avatar

Joined: 11 Nov 2008
Location: United Kingdom
Online Status: Offline
Posts: 35
Quote andrew Replybullet Topic: Beginers question
    Posted: 11 Nov 2008 at 8:07am

Hi all,

I've just started working at a new company and they use crystal reports (that i've never used before), so im currently on the learning curve to get it to work.

My problem is that I cant seem to get Crystal reports to traverse over multiple Database tables (via ODBC).

If I say do....

{table1.users} = {table2.users}

It nukes my entire worksheet so nothing will render other than standard labels.

anything I reference from the first table, will work perfectly, but if I try and request or manipulate any data from any other table - everything dies.
 
I can see the tables fine in the editor, ODBC is running ok and the db itself is fine and intact - Crystal reports was able to work out primary keys/ links and it works fine on other projects - that to all intensive purposes appears top be identical.
 
Now I *know* it has to be something really small and stupid that i've missed, but due to the fact I dont know the product well enough, i'm not sure where or what it is.
 
Any ideas?
 
Thanks in advance!
IP IP Logged
twinkle
Newbie
Newbie
Avatar

Joined: 16 Jun 2008
Location: United Kingdom
Online Status: Offline
Posts: 32
Quote twinkle Replybullet Posted: 11 Nov 2008 at 9:25am
hi!
using the database expert click on the links tab and make sure that the joining link is correct.
IP IP Logged
andrew
Newbie
Newbie
Avatar

Joined: 11 Nov 2008
Location: United Kingdom
Online Status: Offline
Posts: 35
Quote andrew Replybullet Posted: 13 Nov 2008 at 12:50am
Hi  there,
 
yeah the links were joined but the type was incorrect!
 
Thanks again for your help! 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.