Create a Report from Related Tables
I have data in three related tables: Parent, Child, and Grandchild. I want to create a report in Table View that shows certain fields from each of the three related tables.
I want the report to group records based on a field in the Parent Table and subtotal/total records from a field in the Grandchild Record. How do I create such a report?