title: How to convert multiple rows into one row in SSRS?
body: <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>