Sage 100

Crystal Report Export to CSV file. In SAGE 100 STD v2015 I created a Crystal Report that summarizes Employee Earnings from the PR4.EmployeeEarningDeduction file. The report select and adds up the different Earnings Code hours and $$$ on Group Footer #1. I have all sections of the report suppressed except for Group Footer #1. When I print to paper I get one line with the correct earnings total for each employee. But when I export to a .CSV file I get multiple lines (based on the number of different earnings codes an employee had in PR4) but it shows the correct total, just repeated. How do I suppress the details section from repeating the same Group Footer total in my export to .CSV file?

I will format the report with the commas in the line and then export via the TEXT format. you have more control. CSV always exports the detail.

You can do it with Text boxes or with a formula, the text export only exports what is not suppressed.

Or export to Excel, then save from Excel to CSV.

Thank you @JimWoodhead and @BethBowers I tried both methods and they both worked great!

@MichaelMcDonald When exporting to CSV check isolate group sections when exporting. I think that is the one to check.

Thanks @JohnnyPabian The ""isolate group sections"" option worked also - seems like the most straight forward way to go from Crystal Reports 2011 group footer to CSV file format.