Error when Filter with OR..Help!
Error when Filter with OR..Help!
I^m using R&R XBase v9 Edition. I have a filter condition which when I pass gives me a "Unrecognized name or operator at offset 75 of RI_Filter". My Filter string is as follow:____ rptGen.filter = "(INLIST(Mode1," strFilter ") > 0 OR INLIST(Mode2," strFilter ") > 0) AND Date >= {" strDateFrom "} AND Date <= {" strDateTo "}"____I suspect is the "OR" which gives me problem. How do I solve this?__Does anyone know how to solve this?____
=> Error when Filter with OR..Help!
The best way to troubleshoot is to create the filter one clause at a time to see if each can be evaluated independently without error.____Kathleen__R&R Support