To display the data in single row instead of multiple rows

building reports webintelligence
1

Hi All,

I have got a requirement like this:
I have data in the DB table in the following format
Column1 Column2
1 a
1 b
1 c
2 x
2 a
2 y
…and so on
I need to display the data as:
Object 1 Object 2
1 a,b,c
2 x,a,y
3 a,x
…
Does some one has any idea on how to implement this in BO XI R2?

Regards,
Rohit

rohit12 :india: (BOB member since 2008-11-08)