Crystal Reports Displaying records where field 1 is populated but field 2 is empty

[Former Member]

i have 3 fields in my report.

Job id, date on hold, date off hold

I need to display records where there is a value for on hold but where off hold is blank so I can see which jobs are still on hold. How do i do this?

thanks in advance

[Former Member · Accepted solution]

Have you tried adding criteria of:

Not IsNull() and

IsNull()?

Alastair