Hi
How can we convert the Vertical columns to Horizontal Columns
Ex:
1 to 123
2
3
can anybody help me Please?
You can do it the easy way, as a crosstab, and let Cognos do the work. Or, if there is a relatively small finite set of values you want to column-ize you can do it as calculated data items in a list:
Col1=if ([dbcolumn]=1) then ([dbcolumn]) else (0)
Col2=if ([dbcolumn]=2) then ([dbcolumn]) else (0)
etc.
Depending on what you're trying to do you might want nulls rather than zeroes in the ELSEs.
Can you explain some more about your current report and your goal? Are you working with a list or crosstab?
Lists can be pivoted to crosstabs whereas within crosstabs you can swap rows with columns.
Hi,
You could also try using a repeater instead of a list.
Regards,
MF.
HI
THANKS A LOT FOR YOU RESPONSE.........
MY REPORT IS AS FOLLOWS
C C C
O O O
L L L
U U U
M M M
N N N
1 2 3
BUT I WANT TO DISPLAY IT AS FOLLOWS
COLUMN1 COLUMN2 CLOUMN3
EXPECTING REPLY.......
REGARDS,
DWSIVA
use the Rows to coulmn and coulmn to rows swap feature in cognos.