3 Replies Latest reply on Apr 19, 2017 9:20 AM by philmodjunk

    Report Summary

    gilo

      Hi

       

      I have a report sorted by category, and this works perfectly

       

      The only thing I was wondering if it is possible that FM creates a summary of the categories in the first page header, so I have an overview of all categories, and if I want the detail I can consult the report

       

      So that it looks like:

       

      Results:

      Cat 1

      Cat 2

      Cat 3

       

      ---------

      Cat 1

      data1

      data2

      data3...

      -----

      Cat 2

      data1

      date2 and so on

        • 1. Re: Report Summary
          philmodjunk

          Option 1: Use a portal in the header. This requires setting up tables, table occurrences and relationships but depending on the data already in your system, but can be made to work.

           

          Option 2:  Use a Field loaded with data from an ExecuteSQL query

           

          Option 3: if Cat 1, Cat 2, Cat 3 are find criteria, you can set up a system where your criteria is copied to a global field and you put the global field into the header. A script could also loop through your data to copy info from your found set into such a global field in the header.

          • 2. Re: Report Summary
            Jaymo

            The List of Summary field type should also be considered as well.

            • 3. Re: Report Summary
              philmodjunk

              I thought about that, but would think that it would produce a lot of duplicate entries in this context....