title: SSRS values separated with commas in textbox?
body: <p>I have a dataset (stored procedure) which returns the following data</p>
  
  <pre><code>Location      Type
  A             None
  B             None
  C             Three
  D             Two
  E             None
  F             Seventeen
  G             None
  </code></pre>
  
  <p>What I need to do is display in a single textbox the following from the above data 
  <code>C Three, D Two, F Seventeen</code>.</p>
  
  <p>So basically I want to display all Non 'None' types.</p>
  
  <p>Is it possible to do this in SSRS?</p>