title: Concatenating Row Values in SSRS?
body: <p>I'm trying to concatenate a particular record into one field to avoid multiple rows for the record. The issue is that a drive may contain multiple shifts in which each shift may be assigned a different vehicle.</p>
  
  <p>Screenshot below shows what is happening:
  <img src="https://i.stack.imgur.com/ARpwK.jpg" alt="enter image description here"></p>
  
  <p>Both records show the same drive, but the two shifts. I'd like to get the vehicles column to concatenate all vehicles into one field (Vehicles).</p>
  
  <p>My attempt at an expression is:</p>
  
  <pre><code>=Fields!ShortDesc.Value &amp; "," &amp; Fields!ShortDesc.Value
  </code></pre>
  
  <p>Which obviously isn't working.  Any suggestions on what to do to get this working correctly?</p>