locked
Report Parameters and NULL RRS feed

  • Question

  • 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

    Thursday, August 24, 2006 3:42 PM

All replies

  • You're using the correct technique. You haven't missed any hidden options.
    Thursday, August 24, 2006 4:09 PM