Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Multiple tables to one field, 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: Multiple tables to one field,
    Posted: 24 Nov 2008 at 6:58am

Hi all,

I have another problem which im assuming is a stupid one, but is causing problems with Crystal reports!

Bascially, I have 3 tables:

Clients, Logs, Projects
 
All the tables use Client_ID as the index...
 
Projects has the bulk of the data and has Links to Clients and Logs.
 
If I link Clients to Projects - everything works fine, I can create reports without problem.
 
however, If I link in and pull data from logs, it stops data coming from Clients.
 
After playing around, it seems either one or the other will run, but not both toghther.
 
The links themselves:
 
Projects --> log = Left outer join (not enforced)
Projects --> Clients = Left outer join (not enforced).
 
Any help would be greatly appreciated!
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 25 Nov 2008 at 12:35am
Hi
 
Can you post some sample data with the join details,Do you have filters in your record selection formulas to restrict the final output........?
 
Cheers
Rahul
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.