Print report with total by month

[Skylinefranc]

Hello, my accounting department just tasked me with figuring out how to print a report they want. I am fairly new to FM and figured I would ask for some help. We have a list of job numbers and when we search for one we sort it by date, however, when we print it gives total hours worked on that job based on a date basis. I.E all the hours works 8/1/10. They want me to find a way to print the report so it is total hours by month. Any help would be appreciated.

[LaRetta]

In your table, create a calculation (result is date) called c_monthDate which would be:

Date ( Month ( yourDateField ) ; 1 ; Year ( yourDateField ) )

Create your report and include a grouped leading part by this calculation. Sort by this calculation. Place this calculation in the leading part and (from layout level, format date to be only month and year as "August, 2010". Also place your summary field (summary of hours worked) up in the leading part.

Or if you want your total below the detail, you can create another trailing sub-summary of this calculation below the body and place your summary field in it with the words "Total for month of <> next to it. Again, format this merge field by specifying date format of month and year.

So you can find a year's worth of records, sort by this calc and produce a report showing only the totals per month by deleting the entire body.

Edited August 6, 2010 by Guest
Added last sentence

[Skylinefranc]

Thanks for the help, worked great

Edited August 6, 2010 by Guest
Figured out my issue.