Reporting on Null Values 1

[mdj3366]

Hi,

I am using CRXI connecting to a SQL database. This is what data is currently being returned:

010001 10011259 John Doe No
010001 10011259 John Doe No
010001 10011259 John Doe Y Yes
010001 10011259 John Doe Y Yes

The column with the Y has null values. How can I eliminate John Doe completely from the report, since he has Y?

Thanks.

 

[lbass]

You can use group selection. Go to report->selection formula->GROUP and enter:

isnull(maximum({table.Yfield},{table.personID})) or
maximum({table.Yfield},{table.personID}) <> "Y"

-LB

 

[mdj3366]

Thank you, LB!