If I want to filter a field that contains null, it doesn't show on the report. Example:
Let's say I want to show all the customers of the company and I want to have a parameter called amount, which filters the amount that those customers have purchased from the company. The problem is though, if a customer has not bought anything yet (so the amount is null) or one of the employees of the company mistakenly has put a 'space' in the amount filed (so the amount is no longer null, but it's an empty string) it doesn't show up in the report unless I say :
CASE WHEN Amount = '' THEN '[NA]' ELSE ISNULL(Amount, '[NA]') END AS Amount
and also include ('[NA]') in the dataset that amount parameter is populated from:
SELECT Amount
FROM Purchases
UNION
SELECT '[NA]' AS Amount
This works, but it's a pain to handle all the parameters manually. so I was wondering if there is a better way in RS to do this. (Maybe there's a function or a checkbox that I don't know of)
Thanks
