Slow summaries

[Slobey]

Hi everyone,

I wasn't sure where to post this so here goes. I have a solution that tracks jobs. My field people enter information about functions that have been completed and what is left. It also tracks revenue and cost. My problem is that my boss needs to view what he calls a dashboard where he can see a list of all the jobs, what has been done and what is left with all costs and revenue. This means a layout with hundreds of jobs and with the exception of the job number, every field is either a calculation or summary of all the individual functions. It is unbearably slow! Is there a some other way to display this info all together? Are there alternate calculations for a field? I have noticed no real difference with summary vs. sum(field). I placed the records in a portal so only 10 need to load up first, but not much help. Any ideas?

Mike

[Fitch]

You'll need to find a way to use stored fields, using some combination of scripting/lookups/auto-enter or possibly by importing summarized data into a separate reporting table. Unstored calcs and summaries will always bog down with lots of records.