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

Question

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

markshnier__you · Answer

Np, Make the report in the details table. Look up any fields that you need from the parent down to the children.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Forum Discussion

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