Method Community

I have tried every which way to add IsManuallyClosed = False to my report filter but it does not affect the resulting report.  I have tried: IsManuallyClosed is No, = No, <> True, <> Yes, and ISNULL(IsManuallyClosed,0) = 0, = 0, <> 1.  All don't work.  Whats the secret for filtering for IsManuallyClosed = No?  

I take it these filters are not pure SQL expressions.  

Thanks.

Hi Robert,

You should use the syntax [IsManuallyClosed] == False. The Condition Editor can help you with the syntax, for example in this case I clicked Fields > [IsManuallyClosed], then the Equals symbol (which added ==), and then Constants > False.

Also, I believe you want to filter on the line items rather than the sales order? The IsManuallyClosed field exists in both tables, so make sure you select the correct table in the Formatting Rule Sheet Editor:

-Russell

AND IsManuallyClosed = 0  does it.