Suppress details

[Guest_imported]

Crystal Reports V7

I don't want to show a detail line if the following condition is met. Cancel reason does not equal "Refused." Easy. But then I do want to display the line if the cancel reason is empty.

This way if someone has not cancelled a detailed item or cancelled with a reason of "Refused" then the line is displayed. How is this done?

 

[IdoMillet]

IsNull({cancel_reason}) OR {cancel_reason}='REfused'

hth,
- Ido

 

[kenhamady]

depends on what is stored in an 'empty' value. It could be Null or it could be "" (empty string).

If it is the Empty string, use:

{cancel_reason}<>'Refused'
and
{cancel_reason} > ''


If it is a Null Value use:

Not (IsNull({cancel_reason}))
and
{cancel_reason}<>'Refused' Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Guest_imported]

Thanks for the help.

Here's what worked:

{cancel_reason}<> &quot;Refused&quot;
and
{cancel_reason} > ''

 

[Guest_imported]

Thanks for the help.

Here's what worked:

{cancel_reason}<>&quot;Refused&quot;
and
{cancel_reason}>' '