Print Page | Close Window

Question about records in a left outer join

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=7371
Printed Date: 29 Apr 2024 at 6:00am


Topic: Question about records in a left outer join
Posted By: dpakk
Subject: Question about records in a left outer join
Date Posted: 13 Aug 2009 at 4:37pm
I have a problem with a report that uses a left outer join.  What we are trying to do is set a formula field and shared number variable to "0" if there is no record in the right table, and use the value in the right table if one exists.
 
What seems to be happening is that the formula works in cases where there is a value, but doesn't appear at all if there is no associated record in the right table.
 
Does anyone have any suggestions?
 
 
Thanks again for your time.
-Dan


-------------
Dan


Replies:
Posted By: DBlank
Date Posted: 13 Aug 2009 at 6:12pm
if isnull(field) then 0 else field


Print Page | Close Window