Results Set Question

[rcr121]

Hi,

I have a set of 'find results' that I need to manipulate further, and I am not sure what the right direction to go is.

Right now, I am generating an invoice by "period" selection. (User chooses the "period", and FM prints a pre-formatted invoice).

My application is a modification of the FM TimeBilling template, and uses "Time Billing" the and related "Line Items" to produce the report (with a few lookups). The report is sorted by "Project" and produces the total of hours and a subtotal by project on the fly.

But if I have an employee who has multiple timesheets within a period and for a specific project, then the employee is listed multiple times in the report.

For example:

• 
  Period 1-->
  PROJECT A.
  EMP 1=10 hours
  EMP 2=5 hours
  EMP 3=4 hours
  EMP 1=5 hours
  Total hours=24
  

I need to figure out a way to have EMP 1 show up only once in the invoice with the total sum of hours (in this case 15).

I don't know if this is db problem or a scripting one?

Can anyone help?

Thanks

RCR

[-Queue-]

It sounds like you want to create a subsummary by employee and put your employee fields in it. If they are in the body, then they will repeat as many times are there are instances in the found set. You'll also want a summary field for hours in the same part.

[rcr121]

Thanks for the reply.

Can I have nested subsummaries like that? The "employee" subsummary would have to be within the existing "Project" subsummary...I seem to recall I tried this and file-maker wouldn't let me do this, but I might be wrong.

[-Queue-]

Sure, just put the subsummary parts in the order you want and make sure your script sorts them accordingly by their break fields (in a subsummary by X, the break field is X).