How do I exclude two names from my Group Tree

[Bullfrog1870]

I have a simple report getting a list of last name, first name, phone number. It works fine except I want to exclude the names "Smith" and "Jones" from the group selection in the group tree.

How do I do this?

I tried somethinglike {table.lastname} <> "Jones" as a formula but it just returned a True or False.

 

[lbass]

Use the record selection area for this, if you can. Go to report->selection formula->record and enter:

not({table.lastname} in ["Jones","Smith"])

-LB