Method:Classic General Q&A

Re: Report Filtering on IsManuallyClosed = No

robert.cowart — Thu, 22 May 2014 14:26:33 GMT

AND IsManuallyClosed = 0 does it.

Re: Report Filtering on IsManuallyClosed = No

Method_Russell — Thu, 22 May 2014 13:06:07 GMT

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

Report Filtering on IsManuallyClosed = No

robert.cowart — Tue, 20 May 2014 19:34:59 GMT

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.