Show different rows in table, In single view in list report

[Sumanjha]

Hi,

We have a table with data like as below

Object Characteristics
Apple    Fruit
Orange  Fruit
Orange  Color

In the table, characteristics has 3 different value and any object can have all 3 or 2 or 1 number of characteristics. Now In the list report in cognos, We need to show characteristics as 3 columns such that for every object, all its characteristics appear in single row.

Expected output

Object Fruit Color Vegetable
Apple     X
Orange   X      X

I tried having the 3 characteristics separated in 3 queries and then  tried taking union but it didnt work out. Even tried using Repeater, but it throws error. Can you all please provide suggestion on how can this be achieved.

Thanks!

[Lynn]

Hi,

We have a table with data like as below

Object Characteristics
Apple    Fruit
Orange  Fruit
Orange  Color

In the table, characteristics has 3 different value and any object can have all 3 or 2 or 1 number of characteristics. Now In the list report in cognos, We need to show characteristics as 3 columns such that for every object, all its characteristics appear in single row.

Expected output

Object Fruit Color Vegetable
Apple     X
Orange   X      X

I tried having the 3 characteristics separated in 3 queries and then  tried taking union but it didnt work out. Even tried using Repeater, but it throws error. Can you all please provide suggestion on how can this be achieved.

Thanks!

Take a look at the forum etiquette post. You need to tell us what type of data source you have and be more specific in your explanation of the problem. Saying it didn't work or threw an error without explaining more is not giving us enough information to help.

I did something earlier and it didn't work. I tried something else and it threw an error. Would you be able to tell me how to solve my problem? No...you'd need to know more, wouldn't you? The etiquette post explains this and provides some ideas on how to articulate more fully.