Can i do this in a find/sort?

[shannon0331]

I need to figure out how to print a report giving all the employee hours for the entire week. The list needs to show each employee for the dates of 2/9/09...2/15/09. So far i can only get the employee name for the the day not the entire week. I need it to read like this

2/9/09 Joe 8.5

2/10/09 Joe 7.5

2/11/09 Joe 8

2/12/09 Joe 8

2/13.....

2/14.....

For what ever reason i cannot get the employees to list in this manner is it or is it not a find/sort issue or can i or do i have to write a script for it? This is so confusing!I've tried to look up scripting on here as well but i cant get it to do what i need. Any ideas/help would be awesome!

[mz123]

Go into find mode and in the date field, search for

"2/9/09...2/15/09"

In a layout, create a report that has a sub-summary by Date, and a sub-summary by person.

if you have multiple records for one person on a given date and you only want a summary, remove the body from the report.

Sort the report by Date and by Person, and you should get the result you're looking for. If you're not on FileMaker 10, you'll need to go into Preview Mode

So, if your data looks like the following:

2/9/09 Joe 8.0

2/9/09 Joe 1.0

2/10/09 Joe 2.0

2/10/09 Sam 2.5

2/10/09 Sam 4.5

Without a body, the report will look like

2/9/09

Joe 9.0

2.10/09

Joe 2.0

Sam 7.0

With a body, you would see each entry.

Does that help? Need a sample file?

[shannon0331]

I can get the dates i need but i'm not sure if i can create a new layout. I think i have to use sort/find or write a script...the person before tried but it did not come out right so i cant use it.I know there is a way to go through sort/find but i dont remeber how. They need all the employees for the week so to me it comes down to total hrs/through the dates mentioned but it lists all the emplyees for the 9th, then all for the 10th and so on. I need each employee with all dates(days) of that week. Does this make a bit more sense...I WOULD LOVE TO MAKE A SCRIPT FOR THIS...but one that worked,lol.

[mz123]

See the attached file...

Look at the two layouts and the two scripts.

Hope that helps.

Employees.fp7.zip