Summarizing Unique Values Dynamically

September 28, 200619 yr

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

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

September 28, 200619 yr

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

September 28, 200619 yr

Author

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

September 28, 200619 yr

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.