Filters - Either WIPBIlled or WIPWrittenOut has a value
Hi
I was wondering if you could add a Filter/Where that involved two items from a database not just one, at present my report is bringing everything through and I only want it to bring through the records that have values in either WIPBilled or WIPWrittenOut
in a given month. The only snag being sometimes the WIPBilled can be 0 and WIPWrittenOut can have a value minus or positive and vice versa WIPWrittenOut can be blank but WIPBilled will have a value, I could do with only these coming through on the report
but at the moment it is bring through every client in the database even if they havent got a value in either of the two items above.
I was looking to somehow merging the below filters with an OR if that makes sense so only bring through records which have a value in either of the below?
AND Practice.ibvFeesAndWIPTotalsWithCats.WIPBilled != 0
AND Practice.ibvFeesAndWIPTotalsWithCats.WIPWrittenOut != 0
Hope this makes sense!
Cheers
Chris
June 15th, 2011 5:59am