I echo Greg's comment, without knowing the report layout, which sounds unusual, it's difficult to know what to suggest. Is there just one location for each customer?
Random ideas to add to those Greg suggested, just to spark ideas:
Make Customer the Detail record and have the 'detail' as an append and the location as footer. (I'm guessing there are potentially too many detail lines to allow this viability)
A two stage process, as Greg suggests, or perhaps re-arranging the report lines into a new format and then using that for the analysis. For example, using Monarch, move the the Customer and Location sections ABOVE the lines you want as detail, print the revised report and then treat them as appends. Again the layout of the report may preclude this or it may simply be easier to extract separate tables and then combine them as databases (if you have the Pro version.)
If you are able to post a sample of the format I for one would be pleased to have a look at the options.
I have a report that has the append level below the detail level. The customer is one level below and the location is another. I can use the footer to take care of one, but can't seem to figure out how to get the other. Any Ideas?