Creating a summary for a portal field

[Kurt Knippel]

quote:

---

Originally posted by Jeff Abraham:

Hi,

I'm using a portal to view multiple estimates for a particular job. I've tried a grand trailing summary and a sub-summary to view a grand total below the portal. It works fine until someone performs a find in the estimates database and only the found set is summarized. How can I always show a grand total of all estimates? Thanks!

---

Either control the found set, or use the GetSummary function with a constant or global as the break field. This insures that all records are part of the function.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[Jeff Abraham]

Hi Kurt,

Thanks for your reply. Should I put the grand total field in a trailing grand summary or sub-summary part? Also, what is a break field? Should I put my constant field in the break field part of the GetSummary calculation? Sorry if these are basic questions but I do not have a lot of calculation/summary experience. Thanks!

[Jeff Abraham]

Here's more info on my problem:

The related file (invoices.fp5) has products listed from the products.fp5 database. The total field on invoices.fp5 that I'm trying to add up on jobentry.fp5 is calculation with the following value: Sum(LINEIEM_Invoice Number::Line Subtotal).

I got this invoice solution from ISO's Developer's Toolkit. I'm trying to modify it for my own use. I hope this info helps.

[Jeff Abraham]

Hi,

I'm using a portal to view multiple estimates for a particular job. I've tried a grand trailing summary and a sub-summary to view a grand total below the portal. It works fine until someone performs a find in the estimates database and only the found set is summarized. How can I always show a grand total of all estimates? Thanks!

Jeff