Aug 9, 2004 #1 BreffniK Technical User Joined Apr 27, 2004 Messages 24 Location US Thanks for taking the time to read my question. What is the correct syntax to conditionally suppress a section of the report depending on whether or not a field is null? Any advice would be greatly appreciated! Thanks!
Thanks for taking the time to read my question. What is the correct syntax to conditionally suppress a section of the report depending on whether or not a field is null? Any advice would be greatly appreciated! Thanks!
Aug 9, 2004 #2 Turkbear Technical User Joined Mar 22, 2002 Messages 8,631 Location US Hi, Try: Code: IsNull({table.field}) or {table.field}="" Tests for NULL and Blank.. Upvote 0 Downvote
Aug 9, 2004 #3 Kevinski Technical User Joined Jan 4, 2001 Messages 95 Location NZ or even isnull({table.field}) or {table.field} = '' or {table.field} = ' ' Upvote 0 Downvote
Aug 10, 2004 #4 kskid Technical User Joined Mar 21, 2003 Messages 1,767 Location US Just to make sure it's not filled with blanks, isnull({table.field}) or trim({table.field}) = Upvote 0 Downvote