COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: k2 on 27 Jul 2011 04:20:12 PM

Title: Formatting in List Report
Post by: k2 on 27 Jul 2011 04:20:12 PM
Hi All,

I am having a different requirement for a List report. The List report has got around 7 fields say Product ID, Product,Currency Code,Price USD etc...

Here we go, while reporting on a high level against Product ID need to display the product sold in different currencies and the USD equivalent for that currency. I am getting the report out put in this form as List report suppose to do,

ProdID    Curr    PriceUSD
8788    EUR      2478
8788    GBP      4598

Is it possible to diplay in List report like the below,

ProdID    Curr        PriceUSD
8788    EUR,GBP    7076

All your suggestions are highly appreciated. Cheers

¬ K2