how to add "ALL" to parameter 1

[buck149]

Crystal 10, SQL server 2005

I want to set a string parameter where when no value entered, it will cover all values else it will cover entered multiple values or single value.

Thanks

 

[MCuthill]

buck,

Perhaps a conditional record selection formula would work for you. I do not think that you can leave a parameter blank though, may have to use a keyword to trigger an all search.

IF {?Parameter} = "All" THEN
    ~Record Selection~
ELSE
    ~Record Selection~ AND
    {Table.Field} = {?Parameter}

I have never tried this application myself, but it is worth a try.

Hope This Helps,


Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[lbass]

Add "All" to your parameter list of values, and then set up the formula like:

(
IF {?Parameter} <> "All" THEN
{table.string} = {?Parameter} ELSE
if {?parameter} = "All" then
true
)

-LB