Summary field for related table

[nscheffey]

Hi all-

I have what seems to be a straightforward problem, but I can't seem to figure it out. I have a Sales Report layout which shows records from the table LineItem, sorted by Order number. Trailing subsummaries for each Order group show totals of cost and sales, and a Trailing Grand Summary shows totals for all of the Orders displayed. All of these summary fields are defined in the LineItem table and work fine.

Now I need to show at the end of the report a total of the Orders displayed. Although this seems easy I can't figure it out. A GetFoundCount returns the total LineItems displayed, as does a Count of the _kf_Order field. What type of field do I need to create to show the total Orders displayed?

Thanks in advance for any help,

Nate

[comment]

See here:

http://www.fmforums.com/forum/showpost.php?post/135493/

[nscheffey]

Perfect! Thanks much Comment. Probably not something I would have quickly come up with on my own, but makes sense now that I think about it.