Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gaurav1083 on 30 Jun 2015 10:36:25 PM

Title: Column values as header
Post by: gaurav1083 on 30 Jun 2015 10:36:25 PM
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.

Title: Re: Column values as header
Post by: CognosAnalytics on 01 Jul 2015 02:29:02 PM
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
Text only | Text with Images