Display GrandTotal in another Layout

[smr385]

Hi,

I have built a database for an auction. On the main page of the auction I have button to drive various reports for bidders, donors, etc. On that main page I also want to display the current total of all revenues. I have a table built to capture the revenues of all items and fees entered so far, based on a summary report.

I can correctly total all items in the report itself, but when I add the summary field to the main page it doesn't calculate correctly. I've tried GetSummary and can't get that to work correctly either (even though I have set the report to show all records before pulling the value).

This seems like it should be fairly simple, but I've racked my brains and can't figure it out. Can anyone help?

Thanks!

[Søren Dyhr]

Is it the sorting you have forgotten about? Perhaps you need to study the way GetSummary is used, say here:

http://www.kevinfrank.com/download/kf-fast-summary.zip

--sd

[smr385]

Soren:

Thanks for the suggestion. I couldn't use the file in the link (I have FM 7).

I discovered that what's happening is instead of getting one value on the main page, it's generating 3 main pages with the total for each bidder listed on a separate page, instead of bringing over one grand total and keeping it to the main page. I still don't understand how to fix it.

I have a BIDS table with an in item number, an indexed paddle number, the winning bid amount and a summary field called Bidder Total which is the total of the winning bids for each paddle number.

I then have a REVENUES table with the indexed paddle number, a Reg Fee amount the Bidder Total from the BIDS table, a calculated field called Bidder Total Revenue which adds the Reg Fee and the Bidder Total and then finally a summary field called Auction Total Revenue which = Total of Bidder Total Revenue.

On the main page I want to post the Auction Total Revenue.

Thanks!

[Søren Dyhr]

instead of bringing over one grand total and keeping it to the main page

Perhaps some of the details is irrelevant, what if you remove the bodypart, then would only the summary parts show, in a considerably shorter listing.

Another thing that makes me wonder is the relational structure, isn't a table missing or... ?

--sd