How to convert multiple rows into one row in SSRS?
<p>My MSSQL sql query shows the data of Employee Hierarchy with the authcodes as below</p>

<pre><code>ManagerName     EmployeeName    AuthCode
Tim             Peter           csr2
Tim             Peter           sup
Tim             Peter           itil
Tim             Colt            csr2
Tim             Colt            sup
</code></pre>

<p>   The SSRS report shows the results listed below, when I chose the report <strong>parameter= Tim</strong>, the result only shows the top line and not the subsequent AuthCodes whereas the query shows all</p>

<pre><code>EmployeeName    AuthCode
Peter           csr2
Colt            csr2
</code></pre>

<p>   I want the data to show like(it should concatenate the authcodes for the employees):</p>

<pre><code>EmployeeName    AuthCode
Peter           csr2, sup, itil
Colt            csr2, sup
</code></pre>

<p>Could anyone please suggest what I need to do in SSRS so that the data shows all the authcodes with comma separated values?</p>