Print Page | Close Window

Null fields 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=22589 Printed Date: 29 Apr 2024 at 12:30am Topic: Null fields Posted By: bturner Subject: Null fields Date Posted: 07 May 2018 at 8:12am Trying to create a formula that will not incorporate null fields. Replies: Posted By: kevlray Date Posted: 08 May 2018 at 7:21am ?!? You want to filter out all fields that are Null? Posted By: bturner Date Posted: 08 May 2018 at 7:30am Yes. Posted By: DBlank Date Posted: 08 May 2018 at 8:01am NOT(isnull({table.field})) Posted By: kevlray Date Posted: 09 May 2018 at 6:41am And of course, make sure the 'Default Values for Nulls' is selected in the formula editor.  Also another note.  If you are checking a string value for nulls, it is generally more reliable to check for zero length (i.e., len({table.field}) = 0)

Print Page | Close Window