Skip to Content
0
Former Member
Feb 21, 2011 at 09:08 AM

Concatinating Values of an Object in WebI

31 Views

Hi Everyone,

I have to display all the values of an objects for each employee in a single row. For ex below is the data in the report:

Emp Name Contact No. Contact Name

Alan 2311214 David

Alan 2311214 Rachel

Alan 2311214 Mark

John 2114789 Pearl

John 3451134 Joseph

John 3451134 Mili

It should be displayed as follows:

Emp Name Contact No. Contact Name

Alan 2311214 David, Rachel, Mark

John 2114789 Pearl

John 3451134 Joseph, Mili

I have tried to resolve it by making Emp Name as section and adding a horizontal table but it didnt give me the desired result.

I would really appreciate you people could help me to resolve this.

Thanks,

Shreya