Combine a summary report (table 1), with the summary detail (table 2)

I have two tables 1) has agency names  2) has products.   The agency table has summary totals for all the products which is good.   I can view the agency table and click on the totals and get the related products detail.  I need to be able to export  a report that contains both the agency row showing with the summarized totals  AND  detail rows that make up the totals.  Both tables have the same fields.  Is there a way I can get both tables/details on one report?

------------------------------
Barbara Alvarez
------------------------------