Newbies Dave Sutton Posted September 16, 2004 Newbies Share Posted September 16, 2004 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 Link to comment Share on other sites More sharing options...
transpower Posted September 16, 2004 Share Posted September 16, 2004 Add a summary part to your layout (with fields for Account #1 Total Calls, etc.). Link to comment Share on other sites More sharing options...
-Queue- Posted September 16, 2004 Share Posted September 16, 2004 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 Link to comment Share on other sites More sharing options...
Newbies Dave Sutton Posted September 17, 2004 Author Newbies Share Posted September 17, 2004 Thanks!!! I'm still digesting it but I think its close to what I need. Link to comment Share on other sites More sharing options...
-Queue- Posted September 17, 2004 Share Posted September 17, 2004 I didn't blatantly comment the script. So feel free to ask if you're confused about any part of it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7183 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now