Issue with supressing details if a date field is null

0
votes

I am working on a report and i need to supress the details section if a date field is null. I have tried to use the section expert and formula

Isnull({GiftsReport.Date1})=true

I need to supress details section if {GiftsReport.Date1} field is blank or null. But it does not supress it. GiftsReport is a view I am not sure if that makes any kind of difference.

If I use the same formula in selection formula for the report. It suppresses the whole report.

Please if anyone can help me with this I will reallyy appreciate it.

Thanks,

Parvesh Sharma

1
crystal-reportscrystal-reports-2008crystal-reports-xicrystal-reports-2010crystal-reports-8.5

1 Answers

0
votes

The text for the details section's conditional-suppression formula should be:

Isnull({GiftsReport.Date1})

** edit **

// {@null_test}
If Isnull({GiftsReport.Date1}) Then "NULL"
Else "NOT NULL"