Suppress info if criteria is not matched

[crystalfun]

New to Crystal and I am writing a report for stock options where I want the following information displayed:

If grant is cancelled for a reason of "Refused Grant" than display options granted. If grant is cancelled for any other reason than do not display anything.

In the same space I also want to show that if the grant was never cancelled than show the number of options outstanding.

Fields to be used are:
cancel.REASON
grantz.OPTS_GRANTD
formula: @OptionsOutstanding

Thanks in advance

 

[MalcolmW]

Start with creating a report that displays the options granted, as well as the number (count?) of options outstanding.

Next, conditionally suppress the options granted based on the reason.

Next, conditionally suppress the count of the options outstanding based on the cancellation status.

Give it a stab, and let us know how far you get. Malcolm

 

[crystalfun]

Like I said I'm new and using V7. Do I conditionally supress the data by selecting Format field, common, suppress, then enter my formula. I don't want to spin my wheels if I'm in the wrong place.

 

[fluteplr]

yes, the formula should be in the following format.

if {cancel.REASON} <> &quot;Refused Grant&quot; then true else false

 

[MalcolmW]

{cancel.REASON} <> &quot;Refused Grant&quot;
will also work - the key is that the formula result is either true or false. If it is true, then the field is suppressed, else it is not suppressed.
This general formula type (boolean) is used in all the conditional formatting formulas, and the record selection formula.

The most common mistake (at least for me) is to reverse the logic ie put {cancel.REASON} = &quot;Refused Grant&quot; instead of not equal, so if it doesn't work right, check that out.
cheers,
Malcolm

 

[crystalfun]

Thanks for everyone's help. Got this one to work!