Print Page | Close Window

Beginers question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4769
Printed Date: 18 May 2024 at 6:58pm


Topic: Beginers question
Posted By: andrew
Subject: Beginers question
Date 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!


Replies:
Posted By: twinkle
Date 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.

Posted By: andrew
Date Posted: 13 Nov 2008 at 12:50am
Hi  there,
 
yeah the links were joined but the type was incorrect!
 
Thanks again for your help! 


Print Page | Close Window