Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Displaying Records That Have Null Values Post Reply Post New Topic
Author Message
elGroomio
Newbie
Newbie


Joined: 12 Apr 2013
Online Status: Offline
Posts: 4
Quote elGroomio Replybullet Topic: Displaying Records That Have Null Values
     Posted: 22 Aug 2014 at 1:34am
Hi All,

Probably a newbie question but I'll fire away. I have built a report that has the following headers from 4 different tables:

ID, SiteName, SiteManager, SiteInspector, SiteSupervisor

However, some of the sites do not have a SiteInspector or SiteSupervisor assigned on the system. When I run the report these sites are omitted.

I have tried producing an IF statement with IsNull to return a standard text value but it doesn't seem to work.

Please help!

Cheers,
A
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Aug 2014 at 3:33am
this has to do with how you joined the tables and also if you have any select statement that might turn an outer join into more of an inner join. Likely you will want a left join between Sites and SiteInspector and SiteSupervisor tables

Edited by DBlank - 22 Aug 2014 at 3:34am
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.