When you define a condition like this in an advanced report:

Closed By IS NOT someone

You would only get requests that are closed. This is because the above translates to this:

    sr_closed_by <> someone

SQL Server excludes records with sr_closed_by IS NULL. Hence only the closed requests are returned.

To resolve the problem, you can create a condition group like this:

    Closed By IS NOT someone
    OR Closed By IS {No One}

Then it would translate to this:

    sr_closed_by <> someone OR sr_closed_by IS NULL

The requests that are not closed are then returned.
Article #915
Updated On: 12/13/2012 Index
Was this article helpful? Yes | No