[FINISHED] FILTER in DataItemTableView..?

voodoo

Hi,
is it possible to do something like that(this doesn't work...but)
WHERE(Document Type=FILTER(Invoice),Calculate Interest=FILTER(Yes)|Remaining Amount=FILTER(>0))
I need OR operator instead of AND which is by default...

Thnx

Marije_Brummel

This is not possible using properties

You need some code in the triggers using CurrReport.Skip.

Or create a new field that get's populated for this purpose.

Or use a temporary table...

Good luck

awarn

So OnAfterGetRecord you need to do:

if Calculate Interest=false then
currreport.skip;

if Remaining Amount<0 then
currreport.skip;

-a

DenSter

or:

IF (NOT "Calculate Interest") OR ("Remaining Amount" < 0) THEN 
currreport.skip;

voodoo

Thank you all, I already do that