"All" paramaeter for the report

[timbaktuu]

Hi,

I have a parameter {?Name} in my rpt.
I have a record selection formula

If {?Name}

(If {? Name}<>'All' then
{table.name} in {?Name}
Else
True)

My client doesnt want to see some of the names when he selects "all" on the prompt screen.

for instance
data is

harry,
Adam,
David
kathy,
aly ....and so on lots of names

if he runs it for "All", he never wants to see very few names like adam, david at all.


So how can I exclude those from my "ALL" List? I tried suppress formula but still see adam, david..

Thank you for the help.

 

[lbass]

(
(
{?Name}<>"All" and
{table.name} = {?Name}
) or
{?Name}="All" and
not({table.name} in ["Adam","David"])
)

-LB

 

[timbaktuu]

Thank you LB