Grand Total not being calculated

[The Mad Jammer]

Although this problem is happening when I print a report from my "Items" table it has to do with relationships. I defined a report with a Grand Total and broke it down 4 ways as follows, destination, voyage number, container numbr and item. Each item has several records associated with it that are invoice line items. I am only totaling them up on each line instead of breaking the line items out individually. However, when I put a summary field in the Grand Total part (the same summary field used to sum the line items), it comes up with zero. The line items amounts reside in a separate table called "Charges", so i suspect that has something to do with that but I don't see what is wrong with the logic.

Any help appreciated.

the Mad Jammer

[-Queue-]

Summary fields are designed to be local to a table since they deal with the found set for a table. It sounds like you need a calculation field that totals the related items for each record, Sum(relationship::numberfield), and then a summary field that is a sum of the calculation field.

[The Mad Jammer]

-Queue-

I have a line item summary field that is totaling the amount of the records that belong to each item in the report, in fact I have 3 of them, and they are working just fine. SO the "Sum(relationship::numberfield)" is behaving properly. However, one of the grand total fields is the one that's misbehaving. So you are suggesting that I define a summary field in the Items table that sums the summary field in the Charges table? I am getting this correctly? What ever happened to running totals (temporary variables) that are calculated on the fly and then go away when the report is closed? Seems like an easier solution than having to define a field just for this purpose.

Anyway, I'll give your suggestion a try but printing reports and such in FMP 7 is becoming a nightmare. I've got another post in the Printing Issues forum that is killing me and wasting a lot of my time.

Thanks again.

the Mad Jammer

[The Mad Jammer]

Just a follow up, your suggestion worked. You're pretty good at this stuff y'know. However, I was disheartened to see that the all the group fields are not being displyed or printed anymore even though they are on the report. I have 4 break levels in this report and they were working perfectly yesterday. The only issue was summaery data. Today I open the layout and gpreview it and all the group levels are invisible. What a PIA.

Thanks again for you help and insight.

the Mad Jammer

[Søren Dyhr]

Hi JT welcome back!!

Summary fields are designed to be local to a table since they deal with the found set for a table.

...or so we thought!!! Checkout http://www.fmforums.com/threads/showflat.php?Cat=0&Number=159548&an=0&page=0#159548

--sd

[-Queue-]

Thank you, S

[The Mad Jammer]

-Queue- & S