I've been lurking around for while digesting things here in the forums. I finally have encountered a problem that has me totally stumped with FM7 and it deals with summaries and layouts.

I have a table of records, call it Table A, which contains "call" records each stamped with call creation dates and account IDs.

I am trying to create a summary layout which will show, for a given date range, a single line summary that looks like:

Date Total Calls Account #1 Total Calls Account #2 Total Calls Account #3

In other words, no detail records, just summary. Almost like a pivot table view. I can easily generate a detailed report that lists the detail call records, but coming up with an easy way to sum based on date range and account ID has me crazy at the moment.

I know that I can "force" it by creating a temp table and calculating summary records in that table, but I figure there has to be an easier way.

Any ideas?

Thanks in advance.

-Dave Sutton

Add a summary part to your layout (with fields for Account #1 Total Calls, etc.).

If only it were that easy.

Here's a sample of a technique to do it using a couple repeating fields and setting the totals data statically.

Calls.zip

Thanks!!! I'm still digesting it but I think its close to what I need.

I didn't blatantly comment the script. So feel free to ask if you're confused about any part of it.