Print Page | Close Window

Excluding data its not supposed to

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=580
Printed Date: 29 Apr 2024 at 10:05pm


Topic: Excluding data its not supposed to
Posted By: wilkinsmike
Subject: Excluding data its not supposed to
Date Posted: 25 Apr 2007 at 8:09am
I have the following formula as @Analyst
 
if isnull({call_req.assignee}) OR {call_req.assignee} = ""
then "UNASSIGNED"
else {ca_contact_1.first_name} + " " + {ca_contact_1.last_name}
The problem is that if there is not a first and last name, it restricts the record return, even though I have told it to display UNASSIGNED.  can someone explain this to me?


Replies:
Posted By: wilkinsmike
Date Posted: 26 Apr 2007 at 7:45am
I found the issue.  Since I am a newbie to Crystal, I didnt understand the workings of the inner and outer join.  I have corrected the problem.


Print Page | Close Window