Hide / Show Column / Row depending on the conditional prompts

The steps for conditional columns and rows is simple.

1. Create a string boolean variable from the style variable.
2. Write in your condition.
Column logic is different from a row hiding logic.

Column:
1. select the column and its header, u will get a property "Render Variable" (To select the entire column, use the property button to select the "entire column")
2. Set this variable to the boolean stringn that you need to apply.
3. That's it. Job done.

Row:
1. Select the entier row and not the single cell.
2. go to Conditional explorer, select the boolean string.(Yes)
3. The explorer will turn green, select the style variable and click ok.
4. You will get back the entire property column, select the "box type" and set it to "None".
5. Double click on the explorer and the green color will disappear. The row will come back.

I believe this will be useful for me also in future. Hahahaha.

Paging Prompt - Cognos Report

Sometimes when we do things right and fast, we feel everything is easy. But sometime we get stuck on small things.

The logic to create a prompt on displaying different report pages.

1. Create a prompt( with static choice).
2. Create boolean variables (Page1, Page2)
3. Create the static choice.
4. Go to the explorer and click on page1 and in the properties select "rendering" and assign it to the created boolean variable.

It is as simple as that.

Good luck.

Naming Dynamic Columns - Cognos Report Studio 8.2

Ok....... Here I am .. back with the blogging after a long time.

This week I did do some work in Cognos, I will try to update with the problems I faced.

There was a issue where the columns of a crosstab were named as ' 0 ' for all the representatives and the second column was ' 1 ' for all the non representatives. This is because, the data item is been stored in a such a way. The solution is simple here.

Create a data item with the representative and put in a if condition with the respective names. For example:

if ([Dataitem] = 0 ) then ('Representative') else (' Non Representative').

Please keep in mind about the syntax.