Print Page - Splitting One query item in two data item

Title: Splitting One query item in two data item
Post by: BiliBoy on 30 Aug 2013 08:29:05 AM

Hi

I have one query item which has a flag. This Flag produce Y or N value. How can i convert 'Y' in first data item and 'N' in second data item. I do not want use detail filter in order to achieve this. Any expert willing to share their wealth of knowledge for me.

Title: Re: Splitting One query item in two data item
Post by: Lynn on 30 Aug 2013 10:07:39 AM

For the Y data item try this:

Code Select


case [YourFlagItem] when 'Y' then 'Y' else null end

For the N data item try this:

Code Select


case [YourFlagItem] when 'N' then 'N' else null end

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: BiliBoy on 30 Aug 2013 08:29:05 AM