COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: srinu1253 on 26 Apr 2011 04:33:19 AM

Title: Report
Post by: srinu1253 on 26 Apr 2011 04:33:19 AM
IF the Records in the Database are in the below format.
  Name  Value
       A      10
       A      20
       A      30
       B      40
       B      50
       C      60
       C      70
       C      80
       C      90

But I need the Output in the Report as

       Name      Value
         A       10,20,30
         B       40,50
         C       60,70,80,90


Please any suggestions on this would be greatful.

Title: Re: Report
Post by: 167505 on 26 Apr 2011 03:24:36 PM
A simple approach will be using the Repeater or Repeater table.
but i'm not sure that you will get exactly like your desired output, but you have to format your repeater table to show it somewhat like your requirement..

Let us wait for other replies also.

Regards,
Nag