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: http://forums.filemaker.com/posts/40612f7c41.
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.
I'm using FM Pro 12 based on Mac OSX 10.8.2