fperugini Posted April 22, 2003 Share Posted April 22, 2003 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. Link to comment Share on other sites More sharing options...
Pupiweb Posted April 22, 2003 Share Posted April 22, 2003 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 Link to comment Share on other sites More sharing options...
danjacoby Posted April 22, 2003 Share Posted April 22, 2003 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. Link to comment Share on other sites More sharing options...
fperugini Posted April 22, 2003 Author Share Posted April 22, 2003 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? Link to comment Share on other sites More sharing options...
Pupiweb Posted April 22, 2003 Share Posted April 22, 2003 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7868 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now