Forum Discussion

BarbaraAlvarez1's avatar
Qrew Member
2 years ago

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

1 Reply

  • 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)