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

text not visible if condition

Started by Avisto.sbu, 03 Apr 2014 08:18:02 AM

Previous topic - Next topic

Avisto.sbu

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

Lynn

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

Avisto.sbu

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

Lynn

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