Page 1 of 1

RI_FILTER in 10+

Posted: Tue Nov 22, 2005 6:33 am
by Claude_(Guest)
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+

Posted: Mon Nov 28, 2005 9:04 am
by kfleming
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