I need the details section to suppress if a custom date field is blank in Crystal Reports

Alicia Uhacz picture Alicia Uhacz · Aug 7, 2013 · Viewed 7.5k times · Source

I have the following suppression formula in the details section:

{JCJM.udRough} <= #1/1/2013 12:00# AND {JCJM.udTrim} <= #1/1/2013 12:00#

and it works. However, I also need it to suppress if the udRough or udTrim field is blank. When I try to add

OR {JCJM.udRough}=""

it says that a date-time is expected where the blank quotes are. Can someone please help?

Answer

Siva picture Siva · Aug 7, 2013

Try

if ISNULL({JCJM.udRough})
Then true
else false

This is from my understanding from your question if you are searching for something different let me know will try to answer it.