Print Page - text not visible if condition

Title: text not visible if condition
Post by: Avisto.sbu on 03 Apr 2014 08:18:02 AM

Hi,

I must have a text visible if a condition is true and not visible if a condition is false.

The problem is when I use conditional explorer and create a boolean variable with : ( [Commentaire].[Texte]='' ), and I select yes ; almost every fields disappear in the properties :@ :@ :@ :@
why?
how to do a so simple thing, that every other BI tool do so easily?

I have to do that because the text has to be in a visible frame

Title: Re: text not visible if condition
Post by: Lynn on 03 Apr 2014 08:25:56 AM

I think that conditional styles are a zillion times easier than style variables. No variable is required at all. Just select what you want to conditionally style and indicate the desired appearance.

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.0.doc%2Ft_cr_rptstd_modrep_create_adv_cond_style.html

Title: Re: text not visible if condition
Post by: Avisto.sbu on 03 Apr 2014 08:39:25 AM

Thanks, how to add 'emtpy string' value in conditional styles?
Ok I found it in advanced conditional style :)

Title: Re: text not visible if condition
Post by: Lynn on 03 Apr 2014 08:51:06 AM

I suppose that could vary based on your database and the actual content of your field. Is the field storing one or more blank characters such that it appears empty or is it null? Did you try anything other than [Commentaire].[Texte]=''

How about [Commentaire].[Texte] is null

or how about trim( [Commentaire].[Texte] ) = ''

or how about trim( [Commentaire].[Texte] ) is null

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Avisto.sbu on 03 Apr 2014 08:18:02 AM