The report contains report header, page header, regionidentifier header; detail section; regionidentifier footer; page footer; report footer.

In the detail section I have a table/breakdown of each customers spending in ascending order by amount spent.

In the regionidentifier footer I have a summary of purchases for that region eg average sales. Also in this regionidentifier footer(or immediately after?) I want to put in a table showing each customers amount spent alphabetically by their name.Basically the same info as in the detail section but sorted by name not amount. How do I do this?

When I copy the controls from the detail section to the regionidentifierfooter only the first record shows. In other words can I replicate the detail section within the regionfooter section or do something to achieve similar results?