Filter not working in a report!

Tiwaz

Hi everyone.
I have a report, that is fairly simple, but I encountered a problem I cannot wrap my head around.
I have two DataItems (ex. Header and Line) which are linked (using ex. Var1, Var2, Var3).
Plus there is also a filter in Line DataItem property where variable ex. BoolVar=CONST(No).
I added a List in Report Designer where i added Group by using those same variables Var1, Var2, Var3.
In my list I added a table where I grouped data from Line on Line No.
I added Filter on List group to be BoolVar=FALSE.
But it doesn't work!
Can you say what could be the problem. I need to see only those Lines where BoolVar is TRUE.
Thanks in advance!

vaprog

Hello Tiwaz

You said you have a filter in the dataitem on BoolVar=No. Therefore no lines with BoolVar = Yes are in the Dataset and thus, no such lines can be processed in the RDL layout.

Tiwaz

I solved my problem by adding filters using SETRANGE in page action which is to call my report

vaprog

Hello Tiwaz

You said you have a filter in the dataitem on BoolVar=No. Therefore no lines with BoolVar = Yes are in the Dataset and thus, no such lines can be processed in the RDL layout.

RockWithNAV

Tiwaj,

As Vaproj suggested can you please try dong the same, If you want to accomplish something else then please let us know.

Tiwaz

Sorry for the late answer.
Thank you for your response
Sadly, this does not dsolve the problem, I have tried it.
If I remove filter on DataItem and then place a filter in rdlc layout, it will show all Lines is BoolVar = FILTER(TRUE) and no lines if BoolVar = FILTER(FALSE).

Tiwaz

I solved my problem by adding filters using SETRANGE in page action which is to call my report