1 Reply Latest reply on May 24, 2016 4:21 AM by Mike_Mitchell

    Conditional Reporting with Filemaker




      Is it possible to assemble a report in Filemaker based on report items checked by a user.  Say I have 4 sections of a report (each with 1 to 10 fields) but suppose the user only selects sections 1 and 3 (for reporting), then hopefully Filemaker would design a  report with the fields of section 1 and 3. If possible how would Filemaker assemble the sections one after another in the report (for printing)?

      Where could I read up on this (if it is an available feature)? What is the technical name for this feature?


      Thanks for any help.

        • 1. Re: Conditional Reporting with Filemaker

          As I like to tell my customers, anything is possible. It's software.  


          There are a couple of different ways to have a dynamic report with optional sections.


          1) The basic way is to use subsummary parts and manipulate the sort on the report so the parts you want will show. Since a subsummary part will only appear if the found set is sorted on the break field for which the part is defined, you can turn the subsummaries on and off at will.


          2) The more complicated method involves using a Virtual List and manipulating the contents of the list based on what you want. There are plenty of resources online on this technique.


          If the "sections" you reference are all in the same table (or can be defined from there), it's probably easier to use the subsummary method. Otherwise, you might have to resort to the Virtual List.