Hi,

I'm quite new to crystal. So learning quite a lot.

I need to select certain values in a field based on a parameter. When the selection is No it must exclude those 4 values else show everything.

Please help.

if {?Show completed/Cancelled?} = "N" then ({CR073_ISSUES.CR073_ISSUE_STS} <> "C" or {CR073_ISSUES.CR073_ISSUE_STS} <> "T" or {CR073_ISSUES.CR073_ISSUE_STS} <> "R" or {CR073_ISSUES.CR073_ISSUE_STS} <> "X")
else {CR073_ISSUES.CR073_ISSUE_STS} <> " "

Any help is appreciated.

Regards

The problem is that the above if statement does nothing. The report just show all records regardless if it's a yes or a no.