Suppress question

[hereigns]

Very green CR user here - please excuse me if my question is not very clear...CR ver. 8.5

What's the "best" approach (formula) for suppressing a record based on condition but print all other records that do not match the condition? In other words, if I have a field {tblSO.Status} and I want to suppress any records and/or fields in the report that contain "Ready for Invoicing" status.

I tried this formula:

If {tblSO.Status} = "Ready for Invoicing" then ""
Else
({tblSO.Status})

Which as you can see only suppresses the text "Ready for Invocing" it does not suppress the entire record like I want. Hope the information provided is clear.?.?

Your input is appreciated!

 

[synapsevampire]

Rather than suppressing the field, consider eliminating those rows from the report using the record selection formula (Report->Edit Selection Formula->Record) and place:

{tblSO.Status} <> &quot;Ready for Invoicing&quot;

Then there's nothing to suppress, they won't be in the data.

The same thing applies for suppression though.

Right click the Details->Select Format Section->X-2 next to suppress and palce:

{tblSO.Status} = &quot;Ready for Invoicing&quot;

-k