Hello,
I am new to this forum and have been reading and searching through the posts.  I have not been able to find my specific problem, so here it is:

I have a report which displays Freight Bills (FBs) that rode a trip (trucking business).  Those FBs have weights on them.  FB 1 can ride trip #2000, and can be on Leg 1 and Leg 2 of a 3 Leg trip.  I have figured out how to get a sum of the weight in a subreport.  I pass that value to the main report via a shared variable and place that value in the Group footer (grouped by Trip #).

What I need to do now is at the next group level (grouped by company in a multi-company environment) get a total of those weights for the company.  Here is an example of the data

Company 1
  Trip #2000
    Leg 1
      FB1     500
      FB2     750
      FB3     250
    Leg 2
      FB1     500
      FB2     750
    Leg 3
      FB2     750
  Trip #2001
    Leg 1
      FB1     750
      FB2     500
    Leg 2
      FB1     750

Trip #2000 - Total Weight is 1,500 (I can get this number)
Trip #2001 - Total Weight is 1,250 (I can get this number)

The trip total weight is a value in a subreport that I am using in the main report via a shared variable.

My question is:  how can I get my report to total the weight of 1,500 + 1,250 for the company?

Thank you in advance for any and all help and guidance.  I hope my explanation is clear.