Column values as header

[gaurav1083]

Hi,

I am a Cognos newbie and need help
My source data is

Item_type   Item_name
X           Item_1
X           Item_2
X           Item_3
Y           Item_4
Y           Item_4
Z           Item_5

I need to build a report with data shown as below

X           Y            Z
Item_1   Item_4   Item_5
Item_2   Item_4   
Item_3      

Request you to please provide inputs.

[cognos810]

Hello gaurav1083,
Create a repeater table based on Item_type, and set its Rows and Columns property to 3 by 1(or N by 1 ) where N is the possible values for Item_type(3 in the example you showed below). Then, insert a list inside the repeater table with the data item Item_name in it. Finally, connect the Repeater table and the List with the master-detail relationship as Item_type<->Item_type.

-Cognos810