title: SQL Server Report Builder Combining mutliple tables
body: <p>I have two data sets and they are related by an ID number. I am trying to generate a report where a row in table one will be used for a section header for all the related data in table two. That is kind of confusing, so here's some pictures.</p>
  
  <p><strong>Data Set 1</strong></p>
  
  <pre><code>ID   Company  Total Sales
  1    ACME      23000
  2    AJAX      43222
  3    STACK     56700
  </code></pre>
  
  <p><strong>Data Set 2</strong></p>
  
  <pre><code>ID  ITEM   DESC   QTY
  1    A     ADESC   3 
  1    B     BDESC   3
  1    C     CDESC   4
  2    D     DDESC   2
  2    E     EDESC   4
  3    F     FDESC   5
  </code></pre>
  
  <p>Here's what I am trying to get the report to look like.</p>
  
  <pre><code>1  ACME   23000
     A   ADESC   3
     B   BDESC   3
     C   CDESC   4
  2  AJAX    43222
     D   DDESC   2
     E   EDESC   4
  3  STACK   56700
     F   FDESC   5
  </code></pre>
  
  <p>Does anyone know how to do something like this in Report Builder. I'm pretty new to Report builder and am not sure what to look for here? Any help would be greatly appreciated.</p>