COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 14 Dec 2009 01:07:24 PM

Title: Do not show up the recode info in output if the purpose code column is blank
Post by: jd on 14 Dec 2009 01:07:24 PM
Hi,

I am creating the list report with 10 columns. one column name is purpose code.

in report out if purpose code is blank that report do not show up inthe output.

how can I reach this requirement.

thanks in advance.
Title: Re: Do not show up the recode info in output if the purpose code column is blank
Post by: Pramod on 14 Dec 2009 09:04:25 PM
Do you mean the row  shouldnot show in the output?
If that is the requirement then you can use the filter saying purpose code is not null.
Title: Re: Do not show up the recode info in output if the purpose code column is blank
Post by: vinu on 15 Dec 2009 04:44:19 AM
Hi,

create boolean variable with condition [dataitem] is null

then assign to style variable to particular column and make box type property=None

or else u can also use conditionalblocks concept.

Regards,
Venu