3 Replies Latest reply on Aug 27, 2015 6:36 AM by erolst

    Report on Break field doesn't group categories properly

    basilisk2

      FMP 11

      I set up a Conditional Value List using the model suggested in the FMP Knowledge Base and that worked fine. I used it so that I could more easily add Category and Sub-category data to my records. However, when I want to create a sub-summary report that Groups all items from the same Category the report also breaks by each sub category which I do not want it to do.

       

      Here is the Table setup:

      Screen Shot 2015-08-24 at 18.10.59.png

       

      Here is the script to run the report (it's attached to a standard button):

       

      Screen Shot 2015-08-24 at 18.15.55.png

       

      All my other reports based on fields with no Conditional Value List defined field work correctly. I am assuming that when I make the Conditional Value List main field as the Break field, something goes wrong and I need to adjust something somewhere but am stuck on what where and how.

       

      All suggestions gratefully received!

       

      TIA