Data Criteria selection

[tdf2437]

An inexperienced user of Crystal is in need of some assistance. I need to have specific data show on the report. Right now, one specific column shows either of the following results within each row: P, C, or null/blank. I need to prevent any row showing up on the report with a C. Is this done thru the parameters?
Appreciate any assistance, thanks

 

[BettyJ]

Go to Report -->Selection Formulas-->Record

Type
[tt]not ({table.field}='C')[/tt]

 

[bdreed35]

BettyJ's solution will work but you will also lose any records that have a NULL value in that field.
You will need to expand the record selection formula to:

(isnull({table.field}) or {tblEntity.EntityType} <> "C")

~Brian