Method Community

I have a custom report I created in Method Report Designer that Counts my total number of Work Orders over a given period of time. My report includes a field from the Activity table called "IsChangeOrder?".  This field is a Yes/No field, where we check "Yes" if it is a Change Order associated with an original Work Order.  In my report, I would like to filter out (exclude from the Count of workorders) any instances where the "IsChangeOrder?" field = Yes.  I can't see how to set that filter in Report Designer. I've looked in the Property Grid of the field, but can't see how to limit the data.  Any help would be appreciated.  Thank you!

Hi davewalter,

You can do this but you would have to create a calculated field, using an expression like:

Iif(Activity.IsChangeOrder == 1,1,0)

This will return 1 if IsChangeOrder = Yes, and 0 if not. You can then use a Summary function to total up the 1's and 0's, resulting in a +1 for every Change Order.

Hope this helps.

- Justin