AnsweredAssumed Answered

Yearly report for month schedules

Question asked by AlexCarvalho on Jan 30, 2013
Latest reply on Jan 30, 2013 by philmodjunk


Yearly report for month schedules



     I initialy had a monthly report demand.

     We have two fields for job dates: startdate  and  enddate; and we needed to filter these dates based on a given month. The solution to this problem was given by the following post:

     However, based on this solution, now I need to create a report for the whole year, showing all jobs that were performed each month. If a job lasts more than one month   or   starts in the middle of the month and extends to the next month, we need to show this records twice in the year report, and so on. How can I create a report like this?

     I thought about creating another table to show this, but I don't know how.

     Thank you,


     I'm using FM Pro 12 based on Mac OSX 10.8.2