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

Conditionnal display

Started by lahdeb, 27 Dec 2017 03:50:50 AM

Previous topic - Next topic

lahdeb

hello every one , and happy Noel ,

Can you please help me to display list colonne depending on selected prompt :

For ex:In my liste I want to show just information related to a specific brand in a specific store : for example , if I select brand Nike / store X , I will show in my liste just information related to Nike in the store X.

Information shown for each brand are : price by type of clothes , nb of articles available ....

Thank you

Lynn

Quote from: lahdeb on 27 Dec 2017 03:50:50 AM
hello every one , and happy Noel ,

Can you please help me to display list colonne depending on selected prompt :

For ex:In my liste I want to show just information related to a specific brand in a specific store : for example , if I select brand Nike / store X , I will show in my liste just information related to Nike in the store X.

Information shown for each brand are : price by type of clothes , nb of articles available ....

Thank you

How about this:

  • create a prompt page with a prompt control for brand and another prompt control for store
  • create a filter in your query for brand to show only what the user selected
  • create another filter in your query for store to show only what the user selected

I wouldn't call this conditional display since it is just filtering a query to limit the result set. If I've misunderstood the requirement feel free to elaborate.

lahdeb

Thanks Lynn for your replay ,

The purpose is not to filter data ,it is about displaying or hiding list column , I m doing this with boolean Variabls , but I want to do better :)

Invisi

Why is showing or hiding a column not a filter?
Few can be done on Cognos | RTFM for those who ask basic questions...

lahdeb

Invisi , Filter is for data , Variabls are for chart formas and conditional style :)

Invisi

For me it's still limiting the result of data that you describe, so ultimately it's a filter.
Few can be done on Cognos | RTFM for those who ask basic questions...

Michael75

QuoteFor me it's still limiting the result of data that you describe, so ultimately it's a filter.

No, Lahdeb is correct. A filter is reflected in the WHERE clause in the generated SQL, and therefore affects the returned result set.

Here, according to Lahdeb's second post, we're not talking about changing the result set. The requirement is to change the way in which the SAME result set is displayed in the report.

Lynn

The original post sounded more like filtering but a subsequent post mentions showing or hiding list columns.

I didn't respond further because lahdeb indicated it is already resolved using Boolean variables. The comment "but I want to do it better" implies there is something wrong or less than ideal with the current approach but there is no further explanation of what the concern is. I tend to use Boolean variables in the render property for a list column. Job done.