How to store a Sub-summary value

[Patrick Donnelly]

I am running into some difficulty trying to produce monthly sales reports. I basically have a report that shows monthly sales for each vender and then groups these sales by trailerID. For example if in the month of May vender A had sales from 3 trailers, the report would have 3 separate sub-summery parts showing gross sales and net sales for each trailer followed by a grand total of sales from all 3 trailers.

I need to be able to store the gross and net sales value for each trailer to use in another report. I have tried using a Set Field script step and also a GetSummery() function without much luck.

Any good ideas as to how I might accomplish this simple task. Thanks!

[comment]

One way would be to export the reported data, grouped by vendor and trailer, then import it to another table. But why you would want to duplicate this information in the first place?

[Patrick Donnelly]

I have been able to export this data into an excel file successfully. I need to store the sales data in another FileMaker database outside of or network. If I can simply come up with an automated way to store this data in the other database it will eliminate the task of having to export/import. Does that make sense?

[comment]

Export/import can be convenient in this case, because export offers the 'Group by' option, which would otherwise need to be performed by a tedious loop. You can export to a text file (or even a Filemaker file) in the temp folder, and call a script in the target file to import the result - that would make it a one-click operation.

[Patrick Donnelly]

Thanks for the help! I'll give it a shot.