title: Summing Group Items in SSRS 2008 R2
body: <p>I have what I think is a fairly simple problem, but can't for the life of me figure out how to do it (SSRS 2008 R2). I'm using a tablix, as I need to display detail data (not just aggregates)</p>
  
  <p>I have rows of data (shipping costs) and job cost distribution </p>
  
  <p>The (abridged) data in the report is</p>
  
  <pre>
  TrackNo      ShipCost   NoJobs          JobNo        Job Cost
  T1             10.00        1             J1           10.00
  T2             10.00        3             J2            3.33
  T2             10.00        3             J3            3.33
  T2             10.00        3             J4            3.33
  </pre>
  
  <p>So, TrackNo T1 may have 1 job associated with it and TrackNo T2 may have 3 jobs associated. I then pro-rata the costs across the jobs. If each shipment costs $10:</p>
  
  <ul>
  <li>for tracking no T1, job no J1 will get $10.00</li>
  <li>for tracking no T2, jobs J2, J3 &amp; J4 will each get $3.33</li>
  </ul>
  
  <p>I want to have a drill down report like this:</p>
  
  <pre>
  TrackNo     Ship Total         No. Jobs         Job No             Job Total
  +  T1           10.00              1
                                                    J1                   10.00
  +  T2           10.00              2                                                          
                                                    J2                    3.33
                                                    J3                    3.33
                                                    J4                    3.33
  </pre>
  
  <p>In my report, group 1 is tracking no; group 2 (child group) is job no. </p>
  
  <pre>
  TrackNo
      JobNo
  </pre>
  
  <p>Ship Total on the report is <code>First(Fields!ShipTotal.Value)</code></p>
  
  <p>I want to sum the ShipTotal for the entire report (not sum the job totals, as these have rounding errors: e.g. 3.33 * 3 = 9.99)</p>
  
  <p>How can I sum the values shown against group 1 (<code>First(Fields!ShipTotal.Value)</code>)? I'm figuring Scope is the way, but I'm lost.</p>