Reports Central - Filtering Implies AND with No Option for OR
I'm logging this as Navigation since there isn't an appropriate category for this.
In Reports Central, there is the ability to add filtering to the result set. Multiple filters can be added but each one that's used is adding an AND in the statement and doesn't provide any way to set it to OR.
For example, in the Work Requests (wr) table, I want to know which records have a Cost of Labor, Cost of Parts, or Cost of Tools over $1000. If I add filters for all 3 fields, it would result in, (Cost of Labor > 1000 AND Cost of Parts > 1000 AND Cost of Tools > 1000). If I'm looking for records with any of the fields exceeding $1000, I wouldn't be able to do so.
