RI_FILTER in 10+
-
- Posts: 5
- Joined: Tue Oct 10, 2017 12:44 pm
RI_FILTER in 10+
I tried to use RI_FILTER with R&R xbase 10+, and wonder why my filter is not correctly applied in Runtime. When I save it with the report, it works as it should. Only the first half is applied when I use it with RRWRUN.exe and the examples below put in the RRWRUNIN.dbf for my report. No total field is used, only two calculated ones that do not rely on totals. ____Case 1:__DBLIN->TSEXE="Hommes" AND STATDET->DATE_MATCH>=STATDET->debsaisact AND STATDET->DATE_MATCH<=STATDET->finsaisact____Only ^DBLIN->TSEXE="Hommes"^ is applied correctly.____Case 2:__STATDET->DATE_MATCH>=STATDET->debsaisact AND STATDET->DATE_MATCH<=STATDET->finsaisact AND DBLIN->TSEXE="Hommes"____Only ^STATDET->DATE_MATCH>=STATDET->debsaisact AND STATDET->DATE_MATCH<=STATDET->finsaisact^ is applied correctly. ____The filter is done on two separate tables (1 master, 1 relation). I wonder why only one table (the first in filter) is always taken into account.____Is this behaviour as it should ?______Claude____N.B. I think I can bybass it with a parameter table, or this is a little bit more coding.
=> RE: RI_FILTER in 10+
I just tested a compound query in V10+ and mine worked fine. What if you try a totally different filter expression or report? Does that work?____Kathleen__R&R Support