Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: problem when adding fields from more than table Post Reply Post New Topic
Author Message
blue_way2002
Newbie
Newbie
Avatar

Joined: 29 Jul 2010
Location: Egypt
Online Status: Offline
Posts: 4
Quote blue_way2002 Replybullet Topic: problem when adding fields from more than table
    Posted: 06 Aug 2010 at 2:31am
Hi, there
 
i start learn crystal reports 9 , now i have blank report and i connect 2 tables to Database Fields , lets say i have tableA and TableB , okay each table contain , 2 columns , VotersNumbers and VotingPlace the both tables have same values but different in frist column , okay , when i drag first tableA fields , its work okay and bind the data on report , when i try to drag any field from the second TableB , its gives me blank report , i need ideas about understanding how can i connect many fields from different tables into my report
 
thank you ,
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Aug 2010 at 4:23am
did you join the tables correctly using the database expert?
Crystal does not enforce joins until you use fields from both tables in the join (or if you make it enforced in the databse expert joins portion).
What you are describing is that the tables have no matching records with therie current join.
IP IP Logged
blue_way2002
Newbie
Newbie
Avatar

Joined: 29 Jul 2010
Location: Egypt
Online Status: Offline
Posts: 4
Quote blue_way2002 Replybullet Posted: 07 Aug 2010 at 1:24pm
the tables have no match in join , look , the tables is not join in anything , i just have some values on tableA and some values in tableB and want to show up those values together in one report , thats all , but they have not join at all
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Aug 2010 at 4:44am
check to see if it auto-joined
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.