Vertical columns to Horizontal Columns

[dwsiva]

Hi

How can we convert the Vertical columns to Horizontal Columns
Ex:
     1     to   123
     2
     3

can anybody help me Please?

[almeids]

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.

[Feanor]

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.

[MFGF]

Hi,

You could also try using a repeater instead of a list.

Regards,

MF.

[dwsiva]

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

[ggreddi]

use the Rows to coulmn and coulmn to rows swap feature in cognos.