Below is my a example of my table and data.
I am using Visual Studio 2008. I need to concatenate field customer_report with like field ‘number’.
I added a new SQLDataSource and put the query below into it.
Left(Main.CustomerNotes,Len(Main.CustomerNotes)-1) As "CustomerNotes"
From(Select distinct PS2.number,
(Select PS1.customer_report + ',' AS [text()]