Summarizing Unique Values Dynamically

[Jarvis]

I am trying to develop a job costing program that summarizes hours spent working on different projects.

A worker may clock in for one client several times or he may work for several clients just once.

The input might look like this:

Smith Project: 1 hour

Jones Project: 2 hours

Jones Project: 2 hours

Camp Project: 3 hours

I would like the summary report to query all records and generate something that looks like this:

Smith Project: 1 hour

Jones Project: 4 hours

Camp Project: 3 hours

I would like the summary field to keep track of whenever a new client has been added, find all instances of hours for that specific client and then summarize all hours for all clients.

Does anybody have any ideas how to do this?

Thanks,

Jarvis

[Ender]

Use a Sub-summary by Client part with a Total of Hours summary field.

[Jarvis]

Thanks Ender,

I did what you suggested but I don't see the summarized values show up in browse (or any other) mode. In preview mode I cannot see anything at all.

I have attached an example file.

Can you see what I am doing wrong?

Jarvis

Summarize_Hours.fp7.zip

[Ender]

You need to sort the found set by the Sub-summary parts' break fields in order for the part to show up. Sub-summary parts are intended for reports, and only condense in Preview Mode or when the layout is printed.

[Søren Dyhr]

Ah once again in an excel'ish realm.... Ender is absolutely right with his recomendations - this is the way the tool is designed!

Anyways: http://www.kevinfrank.com/download/kf-fast-summary.zip

--sd