TOPIC: Export group totals to csv

Export group totals to csv 10 Dec 2014 21:32 #1752

  • Steve_SIH
  • Steve_SIH's Avatar
  • Offline
I need to export group totals to a csv file. When I view the report it looks correct with one record per group with a total.
When I output the data to a csv file I get one row for each detail record with the total for the group in each record.
For example:
Report:
Group1 total 2
Group2 total 3
CSV:
Group1 total 2
Group1 total 2
Group2 total 3
Group2 total 3
Group2 total 3

Any ideas on how I can get this to work?
I am trying this with the free version 1.8.6.0
The administrator has disabled public write access.

Export group totals to csv 18 Dec 2014 18:11 #1760

  • RonMoses
  • RonMoses's Avatar
  • Offline
Any chance we could get a look at the report itself? It might help find the solution. Have you tried exporting to csv from Crystal?
The administrator has disabled public write access.

Export group totals to csv 08 Jan 2015 17:13 #1769

  • Steve_SIH
  • Steve_SIH's Avatar
  • Offline
I had not tried exporting to csv from Crystal. When I did the output file had the same problem.
I was able to fix it finally by changing the csv export options - I checked the "Isolate Group sections" button.
Thanks for the suggestion of trying it in Crystal. I should have thought of that myself!
The administrator has disabled public write access.

Export group totals to csv 08 Jan 2015 17:25 #1770

  • RonMoses
  • RonMoses's Avatar
  • Offline
Steve_SIH wrote:
I had not tried exporting to csv from Crystal. When I did the output file had the same problem.
I was able to fix it finally by changing the csv export options - I checked the "Isolate Group sections" button.
Thanks for the suggestion of trying it in Crystal. I should have thought of that myself!
No problem, I'm glad it worked out for you.
The administrator has disabled public write access.