Skip to Content
0
Former Member
Jul 31, 2008 at 07:09 PM

exclude specific name from report

16 Views

I am trying to keep John Smith's name from showing up on the report. Below is the record selection from Crystal Reports XI, but it doesn't work. The weird thing is they said it used to work and I made no changes (except to the table names and persons actual name for posting purposes).

Does anyone know why John Smith continues to show up on the report? I would greatly apppreciate any help.

(

{?AMPM} = "Assigned"

AND

ISNULL({TABLE1.Column})

AND

// NOT ({TABLE2.Column} = "1050")

(

not (isnull({@PM}))

OR

(not (isnull({@AM})) AND NOT ({@AM} = 'John Smith') )

)

)

OR

(

{?AMPM} = "NoAMPM"

AND

ISNULL({@PM})

AND

ISNULL({@AM})

AND

ISNULL({TABLE1.Column})

)

OR

(

lcase({?AMPM}) = "wholesale"

AND

(

{@AM} = 'John Smith'

// {{TABLE2.Column} = "1050"

OR

not (isnull({TABLE1.Column}))

)

)

OR

(

lcase({@AM}) = lcase({?AMPM})

OR

lcase({@PM}) = lcase({?AMPM})

)