Crystal XI - Parameter - User doesn't have to select all options 1

[ReillyC]

Is it possible to have more than 2 parameters where selecting options is not required.

For example,

Parameter 1 Select Country
Parameter 2 Select City
Parameter 3 Customer

What if the user just wants to choose the country and customer and skip the city field? Is this possible or does the user have to select a city?

Thanks for your help in advance.

 

[synapsevampire]

A common way around this is to set a default value of All, and in the record selection formula code for "All", as in:

(
If {?MyCity} <> "All" then
{table.city} = {?MyCity}
else
If {?MyCity} = "All" then
true
)

I intentionally format the ELSE with another IF to help assure SQL passthrough.

-k

 

[ReillyC]

Works wonderfully!