Print Page | Close Window

Selecting with null or no record in other table

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4261
Printed Date: 03 May 2024 at 8:32pm


Topic: Selecting with null or no record in other table
Posted By: bwilkins
Subject: Selecting with null or no record in other table
Date Posted: 15 Sep 2008 at 12:33pm
It's probably easier to go over my problem than try to describe it...

Simple two table query. A person table and an emailaddress table. I'm trying to select all people who are flagged as active ( based on field in the person table). The active people may have multiple email addresses. Possible types are business or personal.

I want the report to only show the business address. But when I run into a record in the person file with out a record in email table with type=business that person doesn't show on the report if I select email_type=BUS

But if I don't put that in I get multiple report lines with both the personal and business email addresses.

Thanks


Replies:
Posted By: Crystal Method
Date Posted: 06 Oct 2008 at 9:00am
Try changing the link between tables to either a left or right outer join
 
Database - Visual linking expert - click on link to highlight, then select "Link Options"


-------------
Seagate Crystal Reports 8.5.0.389 in the guise of INFOR:Reports as part of Infor:COM ERP software.


Print Page | Close Window