3 Replies Latest reply on Feb 9, 2016 10:57 AM by jdxxs

    Need help with creating a report from value pairs

    jdxxs

      I am from a programming background and am really missing the availability of for/next loops and indexed arrays in Filemaker scripting.

       

      My problem:

       

      I want to create a report which has a selectable period of months. Let's say January to June 2015 - 1501 through 1506.

      For each line of the report, I have pairs of data arranged as year+month and a value  - such as 1503 and 276 / 1509 and 143 / etc..

      There may or may not be data for a particular year+month - or any of the selected year+months

       

      What I am struggling with is placing the appropriate data in the appropriate field under the appropriate heading.

       

      I can do it using some very painful and laborious methods but am wondering if anyone more familiar with Filemaker methods can point me in the direction of a more elegant and simple way of doing this.

       

      Many thanks for any suggestions.

       

      Jeff