Summary Report

[locator8]

Hi,

I am trying to create a report that summarises how many jobs were logged at particular times of the day. This data would be used to identify trends. eg between 9.00 and 9.30 how many jobs were logged on Monday? Tuesday? etc then between 9.30 and 10.00. I have attached a sample graphic of what I would like to see.

Thanks

David

[TSC]

The answer would depend entirely on how you have the fields set-up in your database. We have a sample database at www.fmdeveloper.com under the tip of the week that addresses creating a sub-summary report. Hope that helps.

Tim Cormier

TSC

http://www.fmdeveloper.com

[Ender]

Hi David.

I don't think you can do a summary report in a grid format like that. Using sub-summary parts you could list for each day, the counts for those times, but each day would be a new section down the page.

Another way that might work is doing the counts with the Count() function through several relationships. ie: Count_Mon0900 (calculation, number result) = Count(Mon0900::RecordID). displaying counts on related fields like this can be slow if there are many related records or if the client is on a WAN.