I have a project that tallies the sales from 20 stores.
Each store will have daily totals
I want to save ONLY the summary field totals to an excel file.
in this type of format:
CUSTOMER# - STORENAME - SUMMARY_OF_ITEMSSOLD - SUMMARY_OF_SALES - SUMMARY_OF_RETURNS - SUMMARY_TOTAL
Then have 20 lines of subsummary data like that I want to save.
Using Export Records it will not export each summary between the 20 breakpoints to list correctly.
However it will PRINT correctly.
So why isn't there a way to PRINT this to a text file / excel file?
If you can print it, you can export it.
Sort your records the way you would for your report. When you set up the export, you get a field list box labeled "group by". Specify the Group By field you use in your report by clicking the needed check boxes.
Then, if you export your summary fields, they should be exported 1 line per group showing the desired sub-summary values.
You also have an option to use the current layout's formats, which may be helpful in your situation if you're trying to match your excel file to your printed report.