Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajua99 on 14 Aug 2015 03:03:03 PM

Title: How to Create where condition in Report Studio
Post by: rajua99 on 14 Aug 2015 03:03:03 PM
Hello,

I need help on how to create this type of formula in the report...

(Current Month) where ((GL Between 100 and 200) and (Seg3 <12 and Seg3 >18))...

For Each Month it is different GL numbers So i can't create the condition at the filter level..I need to do at the report level only in Variables....

Thanks
Mani
Title: Re: How to Create where condition in Report Studio
Post by: bdbits on 14 Aug 2015 06:01:43 PM
You have said nothing about the type or structure of your data source.

The fact that it is different each month says next to nothing about how you want the report to behave in light of this fact.

By variables, do you mean you want to use report prompts?
Text only | Text with Images