How to Summarize Time By Employee

How to Summarize Time By Employee

Post by Frank Perugi » Thu, 24 Apr 2003 03:53:14



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.

 
 
 

How to Summarize Time By Employee

Post by Glenn Schwand » Thu, 24 Apr 2003 04:41:46


You need a summary field that is the total of TimeHourMinutes (call it
TotalTHM).  Your layout would have a header and footer as needed, then a
sub-summary part when sorted by EmployeeID.  Put the EmployeeName field and
the TotalTHM field on that sub-summary part.  Find the records you want to
include in the report, sort by EmployeeID and then print (or enter Preview
mode).  Sub-summary parts do not display in browse mode.


Quote:> 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.


 
 
 

How to Summarize Time By Employee

Post by Kevin Haye » Thu, 24 Apr 2003 20:38:14




Quote:> 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...

Make a summary field that is a total of the time spent for each record.
Then make a layout with sub-summary parts based on employee. Use a
subsummary "before" the body to have the name, ID, etc., and a subsummary
part "after" the body (you don't really need a "body" part) to contain
the total.

Sort by the field designated in the subsummary part (employee ID), and
view in Preview mode.

 
 
 

How to Summarize Time By Employee

Post by Frank Perugi » Thu, 24 Apr 2003 22:09:29


Excellent. Thank you Glenn.

> You need a summary field that is the total of TimeHourMinutes (call it
> TotalTHM).  Your layout would have a header and footer as needed, then a
> sub-summary part when sorted by EmployeeID.  Put the EmployeeName field and
> the TotalTHM field on that sub-summary part.  Find the records you want to
> include in the report, sort by EmployeeID and then print (or enter Preview
> mode).  Sub-summary parts do not display in browse mode.



> > 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.

 
 
 

How to Summarize Time By Employee

Post by Frank Perugi » Fri, 25 Apr 2003 02:13:14


Thanks Kevin!



> > 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...

> Make a summary field that is a total of the time spent for each record.
> Then make a layout with sub-summary parts based on employee. Use a
> subsummary "before" the body to have the name, ID, etc., and a subsummary
> part "after" the body (you don't really need a "body" part) to contain
> the total.

> Sort by the field designated in the subsummary part (employee ID), and
> view in Preview mode.

 
 
 

1. Table Design: Day and Time Zone Permission Table for Employee

I need to design a table to store the day and time zone permission for each
employee. Basically I need to store which day and what period of time the
employee can go to work, so that it can determine for door access or not.

For each, employee1 may go to work on Monday through Friday and from 8-9pm
each day, but no door access on Sat and Sun.

My initial thinking is to have a field "AllowedWorkedDays" with 7-bit value:
Each bit represents on or off for each day. For example, 1111100 means can
go to work from Mon-Fri, but not Sat and Sun.

Now I need to think about the time zone, the straightforword way is as
follows:

MondayStartTime
MondayEndTime
TuesdayStartTime
TuesdayEndTime
WednesdayStartTime
//etc...

But I think this is not a good design.

Please advise. Thanks!!!

2. Merge Repl., Identity Ranges, SQL CE & CompactDatabase

3. Ex-Ingres employees gather -- Alameda Times-Star 7/1/94

4. Netware & DOS platform

5. Summarize problem

6. 6.5 SP5

7. summarizing a group of data

8. How to tell if at First / Last record in Data Control??

9. data smaller than byte and triggers to summarize

10. summarize columns from multiple tables

11. How can I summarize table information?

12. Could someone summarize SP2 status?

13. Need help with summarizing data