If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need to apply the Condition when Active Report variable is Empty

Started by Kiran Kandavalli, 06 Dec 2017 02:13:05 AM

Previous topic - Next topic

Kiran Kandavalli

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

   

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



    CODE 2


   

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


Thanks!
Kiran


Kiran Kandavalli

I have unchecked the option "Drop this condition when Variable is empty" and it worked. Thanks!