Report Only Displaying One Record Per Subsummary Section
I'm trying to create a sub-summary report with four sub-summary sections across three tables with some totals at the end.
The tables are Units -< Wells -< Payments.
I need to sort by Unit status, then by unit (both found in the unit table), then by well (well table), then by payment date (payments table).
I based the report on the Unit table and created a part for "sub-summary by unit status", another for "sub-summary by unit name", another for "sub-summary by well name", and last one for "sub-summary by payment date". I haven't made it to the subtotal/grandtotal part yet because it refuses to display more than one record in either of the last two sub-summary sections. I'm fairly new to this level of reporting, so what am I doing wrong?