Re: Method Report Designer - Filtering a Field

Method_Justin — Wed, 04 Feb 2015 15:32:12 GMT

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

Method Report Designer - Filtering a Field

davewalter — Tue, 03 Feb 2015 17:19:29 GMT

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!

Method:Classic General Q&A

Re: Method Report Designer - Filtering a Field

Method Report Designer - Filtering a Field