filter report based on 2 criteria using a formula

[Injun]

My drill down report has 4 levels .
On the 4th level I need to filter records based on 2 criteria
I right click on the report
Report -> section expert -> supprees no drill down ( X-2)
In the formula editor I have
formula =Trim ({DrillOVB.SYSTEMCONDITIONS})<>"6" and {@OVBJob}>1
It doesnt work.
If I just have
formula =Trim ({DrillOVB.SYSTEMCONDITIONS})<>"6"
it works.
Same way if I use
formula = {@OVBJob}>1 It works.

How can I have both conditions working together.

thanks

 

[bmarks]

That looks to me like it should work. Can you give an example of the data that's in those fields when you test it?

 

[Turkbear]

Hi,

Also try it with an OR instead of AND..

Perhaps there is never a condition where BOTH are true??






To Paraphrase:"The Help you get is proportional to the Help you give.."