Conditional Select

[TEM3]

Using CR 8.5:

I want to user to be able to see one department ({Department Code}) or all departments (by entering "ALL" in the parameter).

This formula (in the select expert box) does not work.

{LABITEM.Location} = uppercase({?Analyst}) and
{LABITEM.Lab Item Number} <> "0" and
(if uppercase({?UnitCode}) <> "ALL" then
trim({LABCASE.Department Code}) = uppercase({?UnitCode}))

Can this be done (or is there another way to do it)??

 

[Madawc]

I don't follow. Surely

@param = "ALL" or @param = trim({LABCASE.Department Code})

Or similar.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

It should be:

{LABITEM.Location} = uppercase({?Analyst}) and
{LABITEM.Lab Item Number} <> "0" and
(
if uppercase({?UnitCode}) <> "ALL" then
trim({LABCASE.Department Code}) = uppercase({?UnitCode}) else
if uppercase({?UnitCode}) = "ALL" then true
)

You have to enter "ALL" as one of your default options in the parameter setup screen.

-LB