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.