Values are separated by comma

[Gnani]

Hi,
I need a sol for the below query..
I have 2 columns country and city in list report. I want cities are to be appeared separated by comma for each country.

Country	Cities
India	Hyd,Blore,Kol,Mum
US	city1,city2,city3

Your help would be appreciated....

Cheers,
Gnani...

[MFGF]

Drag a repeater into your list and populate it with the City item and a text item containing a comma.  Go to the query for the Repeater and add the Country item as a new data item. Finally, add a Master/Detail relationship between the List's query and the Repeater's query, linking on the Country item.

Regards,

MF.