Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Using Two Tables Post Reply Post New Topic
Author Message
crist
Newbie
Newbie


Joined: 21 Jun 2010
Location: Singapore
Online Status: Offline
Posts: 29
Quote crist Replybullet Topic: Using Two Tables
     Posted: 06 Jul 2010 at 10:48pm
Dear expert,
My query is regarding using 2 tables.
both tables have primary keys but when i pull out the 1 field (which is not one of the primary key) in the detail column report - it shows blank.
and it affect my other field - most of the columns now are incorrect detail.
 
How to use the field which is not a primary key in both tables so that the details will be correct?
 
Please help me.
Thanks,
Crist
 
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 06 Jul 2010 at 10:57pm
you can try to change the type of JOIN (e.g.: Inner Join / Left Outer / Right Outer / Full Outer).
 
just right click the link between 2 tables and you'll find the options for it.
 
 
hope it help.
 
Emir W
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.