1 Reply Latest reply on Aug 2, 2010 9:34 AM by philmodjunk

    summary reports...



      summary reports...



      I’m putting together an Inventory / Sales Order database, allowing operators to enter sales of various magazines on a sales entry, with the product_name and product_qty fields as repeating fields with up to six lines on a sales order.

      What I'm trying to do is create a report that summarises all the sales of each magazine for any particular day. For example:


      Transaction 1: Magazine A - 2 copies sold, Mag B - 3 copies sold, Mag C - 2 copies sold

      Transaction 2: Mag B - 2 copies sold, Mag C - 3 copies sold, Mag D - 1 copy

      then report should show:


      Mag A : 2

      Mag B : 5

      Mag C : 5

      Mag D : 1

      Total : 13

      suggestions welcome, thanks

        • 1. Re: summary reports...

          Get rid of the repeating fields, these will be a major problem for you for this database project.

          Instead, define a table of LineItem records you can relate to your sales order record so that you can list the magazines ordered with one type of magazine one each row of a portal to the LineItem records on a SalesOrder layout. If you have filemaker 11, you can open the invoice starting point template for an example of this table and layout structure.

          With that table structure you can create the summary report you want fairly easily.

          Here's a tutorial on just such a summary report using just such a design approach:  Creating Filemaker Pro summary reports--Tutorial