Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: isnull Post Reply Post New Topic
Author Message
Macavity
Groupie
Groupie


Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
Quote Macavity Replybullet Topic: isnull
     Posted: 18 Oct 2013 at 5:44am
question :

table1.item linked to table2.item with left outer join

I have a select statement : table2.prbk = END

a formula : if isnull({table2.item}) then false else true

There is an item that has records in table2 but not with prbk = END

I want to see what comes back from the formula, but only items that have a record in table2 with prbk = END are displayed. there are no supresses.

why isn't the report showing all records from table1 ?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 18 Oct 2013 at 6:00am
the select statement has turned the outer join to an inner join...as NULL is not End.

just as comment on the formula, and it takes a while to get your head around this, but you could shorten the formula to just:

not isnull({table2.item})

and you will get the same results...
take or leave it...I just try to type as little as possible.

HTH
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.