Jump to content

Creating a summary for a portal field


Kurt Knippel
 Share

This topic is 7556 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7556 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.