help with report

Hello. It's been a while since I have done programming work in FMP, so
I'm a little rusty. I was hoping to get a few suggestions here.

Our Filemaker 6.0 solution is made of 20+ files, but for this problem,
I'm only dealing with one. This particular file tracks time against a
job. Here are the basic fields:

Job#, Employee, Date, Hours

I made a summary report that shows the number of hours logged for each
job during a given week. The summary field is "Total Hours on Job,"
and the summary part is set up to summarize on the field "Job#". The
time frame is established by doing a date search.

I now need to add a field to this report that will show the cumulative
hours for each job. So, the final report will look like this:

Job#,Hours this period,Cumulative Hours
1234,7,30
6542,2,96
etc.

Due to the fact that I'm using a sub-summary part, I can't get the
Cumulative Hours field to calculate correctly. I tried doing a self-
join on the "job#" field, but that didn't work.

I would really appreciate any suggestions.

Thanks.
eric


Two files: Jobs and Time
Report needed: Time on jobs in a given week.
.

Relevant Pages

  • Re: Software metering data not showing up in reports
    ... summarize data 12 hours old or older. ... > About to generate report head]Log]!><time... ... > Pacific Daylight Time> ... > New usage processing thread started, ...
    (microsoft.public.sms.inventory)
  • Re: How do I count individual records in the Detailed section of a
    ... By sub report do you mean detailed summary? ... By class I mean Class/Section for instance Acc220 002. ... attributes I mean Class average GPA, class minimum GPA, class maximum GPA, ... I am able to summarize most of the attributes I am looking for in the Detail ...
    (microsoft.public.access.reports)
  • Re: crosstab for durations
    ... I'm not sure how you can do this in a cross tab. ... details section and summarize it in the group footer for the project ... Therefore I would like to produce with crystal reports a crosstab report ... the duration for the period. ...
    (microsoft.public.vb.crystal)
  • Re: numerating pages, and summarize fields
    ... Summaries in the report footer will appear only at the end of the ... If you want to summarize the information on the page, ... > report header section1 ...
    (microsoft.public.vb.crystal)