title: From a one to many SQL dataset Can I return a comma delimited list in SSRS?
body: <p>I am returning a SQL dataset in SSRS (Microsoft SQL Server Reporting Services) with a one to many relationship like this:</p>
  <pre class="lang-none prettyprint-override"><code>ID  REV Event
  
  6117    B   FTG-06a  
  6117    B   FTG-06a PMT  
  6117    B   GTI-04b  
  6124    A   GBI-40  
  6124    A   GTI-04b  
  6124    A   GTD-04c  
  6136    M   GBI-40  
  6141    C   GBI-40
  </code></pre>
  <p>I would like to display it as a comma-delimited field in the last column [Event] like so:</p>
  <pre class="lang-none prettyprint-override"><code>ID  REV Event  
  6117    B   FTG-06a,FTG-06a PMT,GTI-04b  
  6124    A   GBI-40, GTI-04b, GTD-04c  
  6136    M   GBI-40  
  6141    C   GBI-40  
  </code></pre>
  <p>Is there a way to do this on the SSRS side of things?</p>