Blog Pro de Jean-Baptiste HEREN

Notes d'un consultant Freelance en Informatique

To content | To menu | To search

Cognos 8 Report Studio's Conditional block

Conditional blocks allow you to add multiple reports to one page. By defining multiple zones, for example, you can coose between a Synthesis and a detailed table.

To make use of conditional blocks, you will need :

1 - one value prompt

This prompt will allow the user to choose the conditional block to display. It can be located on a promt page, on the reports pages themselves or both.
On this particulat prompt, set a parameter name, auto-submit to 'Yes' and define a static list of choices.

2 - one variable for conditional choices

in menu view->variables, create a string variable to be used as conditional variable in the conditional block. and set Expression to get the prompt choice parameter value.
Create as many values as conditional blocks you need, keep the same ones as in the conditional prompts.

3 - one conditional block

On report's page, add a conditional block and set the conditional variable to the one you have created & select values you vant to use.

Then, you only have to select one value in current block, add contents to it. Select another value, add contents... it's done.

Jean-Baptiste Heren

Author: Jean-Baptiste Heren

Stay in touch with the latest news and subscribe to the RSS Feed about this category

Comments are closed


no attachment



You Might Also Like

result_crosstab.png

Cognos Report : Display a different measure in row for the aggregated column

Following tip is when you use a Relational Datamodel (DMR). In a Cognos Report crosstab, If You need to Display different measure in the aggregated column, you can do it using a simple if-then-else...

Continue reading

Cognos 8 - convert a member unique name from one hierarchy to another

If you need to build any report or Event studio Query using the same data from different packages; and you want to prompt just once. You can convert the member unique name from one hierarchy to...

Continue reading