Input values not in database 1

[antmoe3]

In the database I have the values for a dept of 01, 03, 04, 06, 07. When the user is prompted and enters the value "DROP", the records retrieve will reflect dept 01, 03 and 06. How do I do this? Do I create this as formula in the Select Expert?

 

[lbass]

What version of CR are you using? Create a string parameter (field explorer->parameter->new) called {?dept}, choose "allow multiple values", and enter the dept numbers as potential values and also enter "drop" (without the quotes) as a potential value. Then go to report->selection formula->record and enter:

(
if {?dept} <> "drop" then
{table.dept} = {?dept} else
if {?dept} = "drop" then
{table.dept} in ["01","03","06"]
)

-LB

 

[antmoe3]

CR 10