5 Replies Latest reply on Apr 9, 2010 3:13 PM by comment_1

    Report Only Displaying One Record Per Subsummary Section

    spectre6001

      Title

      Report Only Displaying One Record Per Subsummary Section

      Post

      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?