2 SETFILTERS

roshini

Hi Nav Experts,

How to display customer records by using two different setfilters in a report.

Example:

setfilter 1 : SETFILTER(Customer."No. of Due Months",'<=%1|>=%2','0','9');
setfilter 2 : SETFILTER(Customer."Closing Date",'<%1|>%2',1,31);

I tried with single data item it is filtering last setfilters data.

can any expert suggest me how to handle??

Thanking You

kine

You mean with AND or OR between them? It means you want records fulfilling both or one of them? If both, set them both, if one of them, it is not possible in one loop...

garak

roshini wrote:

Hi Nav Experts,
setfilter 1 : SETFILTER(Customer."No. of Due Months",'<=%1|>=%2','0','9');
setfilter 2 : SETFILTER(Customer."Closing Date",'<%1|>%2',1,31);

Buth filtercriteria is like you wrote (it's an AND). Or need you an OR filterconstruct?
If yes you must filter first "No. of Due Months" and after getting the data and work with them for example in a loop and store there temp, filter again with "Closing Date" and work with this data

roshini

Thanks for your response.

as I want both the conditions satisfy. means AND.