Restrict Values to Parameter Field Default Values List

[nes105]

I am using the following formula in v8.5 to enable the user to select one or more values from the Parameter Field Default Value list:

(IF{?VendCode}<>"ALL" THEN {ICITEM.SEGMENT1} = {?VendCode} ELSE IF {?VendCode}="ALL" THEN TRUE)

The formula (and default value list) also includes an "all" selection, so that the user may select "all", instead of adding all values, one at a time. When "all" is selected, I would like only those values from the default values list to be returned. Instead, all values from the entire table are returned.

Thanks

 

[lbass]

I think you would have to specify those defaults in the selection formula, as in:

IF{?VendCode}<>"ALL" THEN
{ICITEM.SEGMENT1} = {?VendCode} ELSE
IF {?VendCode}="ALL" THEN
{ICITEM.SEGMENT1} in [1,4,7,11] //assuming this is a number field

-LB