Complex Filter - Filter out two different check on same field in multiple OR statements

[LaurensKr1]

Hi,

I have a report with 3 level of OR statements. Example below.

Field1_Mod=isnull

name=Task 1

name_Mod=cicontains

OR:1:Field1_Mod=isnull

OR:1:name=Task 2

OR:1:name_Mod=cicontains

OR:2:Field1_Mod=isnull

OR:2:name=Task 3

OR:2:name_Mod=cicontains

But on Field 1, I want to do an additional check to exclude the task if FIeld 1 contains 0 in it. 

So I modified the code as below:

Field1_Mod=isnull
AND:1:Field1_Mod=cinotcontains

AND:1:Field 1_=0

name=Task 1

name_Mod=cicontains

OR:1:Field1_Mod=isnull

OR:1:name=Task 2

OR:1:name_Mod=cicontains

OR:2:Field1_Mod=isnull

OR:2:name=Task 3

OR:2:name_Mod=cicontains

The code works find for Task 1, but I want to apply the same logic for Task 2 and Task 3. 

I am not sure how to write the same AND:1: code but for OR:1 and OR:2.

Is that even possible?

[skyehansen]

if you got task1 working, you should be able to do the same for task2 and 3. Just think of it as creating three different sets of filters, and just adding the "OR:__:" part to the front of each filter set.