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

    Need help with creating a report from value pairs


      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.