Exporting Summary Report
I've got a report where I deleted the "Body" part, it's just a sub-summary and a trailing grand summary. In the sub-summary section I have a few fields pertaining to funding sources, and some summary fields with the sum of the values items charged to each funding source.
This all looks and works correctly in FileMaker, but when I either export or save as Excel it shows the grand total for the summary fields, either on the first record only then blank, or it has the grand total for every record.
Basically what I want is exactly what's on my screen, just in Excel. I want a line for each fund and then a total of how much was spent on each fund.