Author Topic: Need to apply the Condition when Active Report variable is Empty  (Read 200 times)

Offline Kiran Kandavalli

  • Community Leader
  • *****
  • Join Date: Jun 2011
  • Posts: 80
  • Forum Citizenship: +0/-0
Team,

In the Report I am trying to implement the condition when Active Report is Empty, but it is not working. Please suggest me how to implement this.

1) I have added check Box Group and given Label as "Include Active", so when the check box is checked Active Records need to be shown...else we should exclude those records.
2) From Check box Group I created a connection to a Chart
3) In the Chart Container Filter - I applied the condition when Checkbox Active Report Variable is Empty , but it is not working

   Tried below conditions in Chart Container Filter
   
    CODE 1

   
Code: [Select]


    (v_ABC is empty AND  [Active Data item] not in 'Y')
    OR
    (v_ABC in 'Include Active' AND  [Active Data item] = 'Y')
   
   


    CODE 2


   
Code: [Select]


    ( '' in v_ABC AND  [Active Data item] not in 'Y')
    OR
    (v_ABC in 'Include Active' AND  [Active Data item] = 'Y')
   
   

Thanks!
Kiran

« Last Edit: 06 Dec 2017 02:15:23 am by Kiran Kandavalli »

Offline Kiran Kandavalli

  • Community Leader
  • *****
  • Join Date: Jun 2011
  • Posts: 80
  • Forum Citizenship: +0/-0
I have unchecked the option "Drop this condition when Variable is empty" and it worked. Thanks!

 


       
Twittear