How to Summarize Time By Employee

[fperugini]

Hello All,

I am a beginner with FileMaker 6 and need some help with reporting.

I have a TimeCards Database which contains these fields and some others:

EmployeeID

EmployeeName

Dept

JobNo

JobName

EntryDate

TimeHourMinutes

A Form collects Entries by different Employees where they record time spent on a particular Job.

Some sample records might look like this:

"1000" "Dept 1" "John Smith" "1048" "Job No 1" "04/20/2003" "3.25

"1000" "Dept 1" "John Smith" "1055" "Job No 2" "04/20/2003" "2.0"

"1002" "Dept 2" "Mary Brown" "1048" "Job No 1" "04/19/2003" "1.5"

"1002" "Dept 2" "Mary Brown" "1055" "Job No 2" "04/20/2003" "3.25"

"1002" "Dept 2" "Mary Brown" "1060" "Job No 3" "04/21/2003" "4.0"

and so on...

I need to produce a report which Lists all the employees, and a summary of the total time they charged against all jobs, i.e.

John Smith 32.5 hours

Mary Brown 38.0 hours

and so on...

I have built a form which collects the start and end date for the report, and I placed a "Generate Report" button to produce the report.

How would I go about generating a report of this type? I just need some general ideas or approaches, and I can take it from there...

Thank you.

[Pupiweb]

In general:

build a columnar report layout with a subsummary section by EmployeeID

Create a TotalHours Summary field, total of TimeHourMinutes, by which you'll get the total amount of hours spent by each employee

[danjacoby]

BTW; Subsummary parts only show up in Preview mode (or on a printout). Also, the part will only show if the records have been sorted by whatever field you set the subsummary part for.

[fperugini]

Ok, I can get the summary fields to work, but how do I restrict a report to filter between two dates and still show summaries for each user?

[Pupiweb]

You've to run a search to select the records you want, then run a script that sorts records properly and brings you to the subsummary layout