title: SSRS 2005: Change column display from item column value/one row to something else?
body: <p>I have a table/dataset like:</p>
  
  <pre><code>1/1/2009 | Training 1 | Mike
  1/1/2009 | Training 1 | Bill
  1/1/2009 | Training 1 | Steve
  </code></pre>
  
  <p>I would like to display as</p>
  
  <pre><code>1/1/2009 | Training 1 
  Mike, Bill, Steve
  </code></pre>
  
  <p>The idea is that the resulting printed page space is not wasted by printing one column on most of the page down but shortening the space to either a horizontal list or a columned result inside that field. What is the best way?</p>
  
  <p>I would like to handle this is report designer as opposed to mucking with SQL results. I see several ways that gets close but not exact. I'm on SSRS 2005. </p>