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...
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.