title: SSRS Group Summary - Multiple Records in Single Row
body: <p>I need to reformat an SSRS document to summarize the same Item and Lot Numbers on one line instead of breaking them out on individual lines by the PKG #.</p>
  
  <p>For example: </p>
  
  <pre><code>ITEM1234, LOT1234, PKG #'s 1 - 5, 8, 11, 16
  </code></pre>
  
  <p>The current format is as such:</p>
  
  <pre><code>ITEM1234 / LOT1234 / PKG1 
  ITEM1234 / LOT1234 / PKG2 
  ITEM1234 / LOT1234 / PKG3 
  ITEM1234 / LOT1234 / PKG4 
  ITEM1234 / LOT1234 / PKG5 
  ITEM1234 / LOT1234 / PKG8 
  ITEM1234 / LOT1234 / PKG11
  ITEM1234 / LOT1234 / PKG16
  </code></pre>
  
  <p>Ideally, we would like to see the item and lot on one line, and a combination of all packages on only <strong>one</strong> line following, turning this 8 line combo in 2 lines.</p>
  
  <pre><code>ITEM1234 / LOT1234 
  PKG 1,2,3,4,5,8,11,16
  </code></pre>
  
  <p>Does anyone have an idea on how would we go about doing this?</p>