Passing Discrete Null Value in Multi-value Parameter 1

[elansienna]

I have a report that was built using the following record selection on a parameter field:

(if {?Service Recipient Group} = "ALL" then true else
{PROBSUMMARYM1.RECIPIENT_GROUP} = {?Service Recipient Group} or
{PROBSUMMARYM1.RECIPIENT_GROUP} like {?Service Recipient Group} )

While "ALL" brings back all records including nulls, I need to be able to pass a value in and bring back just the null values. Any help will be appreciated.

Elansienna

 

[lbass]

Add a "Null" option to your parameter pick list and then try this:

(
if {?Service Recipient Group} = "Null" then
isnull({PROBSUMMARYM1.RECIPIENT_GROUP}) else
if {?Service Recipient Group} = "ALL" then
true else
(
{PROBSUMMARYM1.RECIPIENT_GROUP} = {?Service Recipient Group} or
{PROBSUMMARYM1.RECIPIENT_GROUP} like {?Service Recipient Group}
)
)

-LB

 

[elansienna]

This works great! You are absolutely the best!!! Thanks for the quick response.