Print Page | Close Window

= Null (in Record Selection) Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2022 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=5992 Printed Date: 02 May 2025 at 9:46pm Topic: = Null (in Record Selection) Posted By: DaveCND Subject: = Null (in Record Selection) Date Posted: 03 Apr 2009 at 7:16am I'm gathering data from a few tables and I need to gather some data where a particular field is NULL. in my selection I have blahblahblah = 1 and somethingelse = this and whatIneed = NULL I can't seam to find the magic word in CR to tell it I only want records that have "whatIneed" = NULL. Thank you =) Replies: Posted By: DBlank Date Posted: 03 Apr 2009 at 7:24am blahblahblah = 1 and somethingelse = this and isnull({table.whatineed}) Posted By: DaveCND Date Posted: 03 Apr 2009 at 7:28am ok I'm kicking myself now heheh well thanks looks like this would do it.

Print Page | Close Window