Conditionally suppress report footer 1

[Bennie47250]

Using CR7.0

We have a service dispatch form that is used to dispatch for several accounts, Lets say Apple, Grape and Banana

Depending on the account and the type of service, we include different documents that are in the report footers (we currently have 15 footers) and suppress or print as appropriate. Adding a new document and having problems getting the latest to work.

We only want this to print if the
Account is Apple and
Reason is spoiled and
Call Type is Emergency and
Stores is Big

The formula I’m using but is not working is

{ Account}<>"Apple" or \\ Will not print for the other accounts
Account_Name}="Apple" \\ So it prints for Apple
and {Reason} <> "Spoiled" \\ So it does not print for tickets other than spoiled
and {CallType} = "Emergency" \\ So it prints for Emergency call types
and {Store} = 'Big' \\ So it prints for only Big store types

I have been unable to get the correct formula to condition all 4 of these conditions so it is not suppressed and will print. We will have other tickets for Apple and the reason will be different than Spoiled but this page will print.

Thanks for your suggestions on how to correct.

Thanks
Bennie

 

[lbass]

Use a suppression formula like this:

{table.Account} <> "Apple" or
{table.Reason} <> "Spoiled" or
{table.CallType} <> "Emergency" or
{table.Stores} <> "Big"

Note that this formula will be based on the last record in the report, so I'm assuming all records within the report have the same values for these particular fields and that they may or may not meet the above criteria.

-LB

 

[Bennie47250]

That seems to work, but I'm not sure I understand why.

Yes lbass all the records for the report are the same. The way this report works the user is prompted for a specific ticket number.

Thanks

 

[lbass]

This formula suppresses the footer if ANY of the conditions are true, i.e., if the report is not for "Apple" or not for "Spoiled", etc.

-LB