1 Reply Latest reply on Jun 2, 2014 10:23 AM by philmodjunk

    Report showing project due dates, sorted weekly

    firth5

      Title

      Report showing project due dates, sorted weekly

      Post

           I'm looking to generate a report that will have a sub-summary row for each week in a year.

           The sorted records below it will list the projects that are due that week.

           My first stumbling block is figuring out how to get a sub summary field to be the exact dates of a week.

           Any help would be appreciated.  Thank you so much!

           (Since Gantt charts are so difficult to create in native FM, I'm trying to tackle the report from a different angle.)

           ---

           FMP13.  Windows.

            

        • 1. Re: Report showing project due dates, sorted weekly
          philmodjunk

               Assuming that each project due date is in a different record of the same table...

               ProjectDueDate - DayOfWeek ( ProjectDueDate ) + 1

               will compute the date for Sunday of the same week for any ProjectDueDate with a date from the same week.

               You can define this as a calculation field, specify it as the "when sorted by" field for your sub summary layout part and then sort your records by this calculated date to group your records by week.