Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Excluding data its not supposed to Post Reply Post New Topic
Author Message
wilkinsmike
Newbie
Newbie


Joined: 25 Apr 2007
Location: United States
Online Status: Offline
Posts: 2
Quote wilkinsmike Replybullet Topic: Excluding data its not supposed to
    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?
IP IP Logged
wilkinsmike
Newbie
Newbie


Joined: 25 Apr 2007
Location: United States
Online Status: Offline
Posts: 2
Quote wilkinsmike Replybullet 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.
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.