My customer wants "all" in param values..... 1

[AlanApplications]

All my data runs in this report, but I thought this was the way to allow "ALL" as a parameter....help?


{workorder.status} = {?Status} and
{workorder.worktype} = {?Worktype} and
{workorder.leadcraft} = {?technican}
= iif({?Status}="All",{workorder.status},{?Status}) and
= iif({?Worktype}="All",{workorder.worktype},{?Worktype}) and
= iif({?technican}="All",{workorder.leadcraft},{?technican})

 

[bdreed35]

Try it this way:


(
if {?Status}<>"All" then
{workorder.status}={?Status}
else if {?Status}="All" then
true
) and
(
if {?Worktype}<>"All" then
{workorder.worktype}={?Worktype}
else if {?Worktype}="All" then
true
) and
(
if {?technican}<>"All" then
{workorder.leadcraft}={?technican}
else if {?technican}="All" then
true
)

~Brian

 

[lbass]

Please don't dual post. I didn't see this, and responded to your other post.

-LB