title: SSRS - Use Join() inside a tablix outside a group
body: <p>I am using Microsoft SQL Server 2017 with Reporting Services and Report Builder 2016.</p>
  
  <p>I got a DataSet which looks like:<br>
  <a href="https://i.stack.imgur.com/oVmuu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oVmuu.png" alt="DataSet example"></a></p>
  
  <p>I've already created a tablix which groups by Name and shows each Name one time and the count of the Name in the table. Something like this:</p>
  
  <blockquote>
    <p>4 x Foo<br>
    2 x Bar</p>
  </blockquote>
  
  <p>Now, I want to get a text containing all comma separated Names (each Name only one time) and a text containing all comma separated Name counts. It should look like this:</p>
  
  <blockquote>
    <p>Foo,Bar<br>
    4,2</p>
  </blockquote>
  
  <p>How is this possibile using SSRS Report Builder?</p>
  
  <p>I already tried:  </p>
  
  <ul>
  <li>Use Join() inside tablix (not working)</li>
  <li>Use a List instead of a tablix (generally working but it repeats the items vertically and not horizontally)</li>
  </ul>