Trying to create a parameter and query where a field is empty or null 1

[piovesan]

Hi;
I have created a report where I want to create a parameter that allows the user to select all records where a field is either not null... or null... I THINK I need to determine if the field is "empty".... so I am trying to create a selection using a parameter called Occ Class Entered? like this....

({?OCC CLASS ENTERED?} = "NULL" and
Iif (IsEmpty ({FIRE_GRD.GRP_DIV}) ,0, {FIRE_GRD.GRP_DIV})
) or
(
{?OCC CLASS ENTERED?} = "NOT NULL" and
{FIRE_GRD.GRP_DIV} in ["C", "B2", "A2"])

But I keep getting an error that a ")" is missing.... I cannot figure out where, or if this is just wrong....
Thanks!

 

[briangriffin]

if {?OCC CLASS ENTEREED} = "Null" then
isnull({FIRE_GRD.GRP_DIV})

else

{FIRE_GRD.GRP_DIV} in ["C", "B2", "A2"]

should do it. Are C, B2, and A2 the only possible values? If so, you could simplify a bit:

if {?OCC CLASS ENTEREED} = "Null" then
isnull({FIRE_GRD.GRP_DIV})

else

not (isnull({FIRE_GRD.GRP_DIV}))