Select of Not

[TEM3]

Using CR 8.5 and Oracle 9i tables:

I thought this would be easy, and it probably is. I just can't come up with the solution.

I created a parameter that I want the user to enter either "ALL" or a gun serial number. If they enter anything else but "ALL" they get the weapon with the matching serial number. If they enter "ALL" they get the entire list (no selection).

Can't make it work. Suggestions please?

 

[TEM3]

That should be "Select OR Not".

 

[lbass]

(
if {?Parm} <> "All" then
{table.serialno} = {?Parm} else
if {?Parm} = "All" then
true
)

Make sure you have added "All" in your list of parameter options.

-LB

 

[TEM3]

I was trying to be too fancy. The below seems to do the job.....

if uppercase({?Desired}) <> "ALL" then (uppercase({CHEMINV.Instrument Serial Number}) = uppercase({?Desired}) and
{CHEMINV.Asset Class} = "F")
else ({CHEMINV.Asset Class} = "F")

Thanks.