SUM string with comma (SQL Server Reporting Services)

Question

I would like to get string sum check "column 1".

Do you have idea how to do it?

jack, john, bill, joe, sindy

Something similar to

=JOIN(Fields!Column1.Value, ",")

Answer 1

SAMPLE TABLE

CREATE TABLE #TEMP(COLUMN1 VARCHAR(100),COLUMN2 VARCHAR(100))

INSERT INTO #TEMP
SELECT 'jack',1  
UNION ALL
SELECT 'john',1 
UNION ALL
SELECT 'bill',1
UNION ALL
SELECT 'joe',1
UNION ALL
SELECT 'sindy',1

QUERY

If you need the value with comma separate values and count, you can avoid query before UNION ALL and execute the query only after UNION ALL.

SELECT NULL,COLUMN1,COLUMN2
FROM #TEMP

UNION ALL

SELECT DISTINCT 'TOTAL',
-- Here we convert to comma separated values
SUBSTRING(
            (SELECT  ', ' + COLUMN1
            FROM #TEMP T2 
            --WHERE C2.Id=Id AND C2.COLUM=COLUM            
            FOR XML PATH('')),2,200000) COLUMN1,
COUNT(COLUMN1) COLUMN2
FROM #TEMP T1