RI_FILTER in 10+

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Claude_(Guest)
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

RI_FILTER in 10+

Post by Claude_(Guest) » Tue Nov 22, 2005 6:33 am

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.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: RI_FILTER in 10+

Post by kfleming » Mon Nov 28, 2005 9:04 am

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

Post Reply