Posted by Barbara Brazil on August 06, 2010 at 13:15:00:
In Reply to: TOTAL annoyance posted by Grant Foraker on August 06, 2010 at 12:30:27:
Grant:
When you output to a .csv using the PRINTER statement it should look something like this:
PRINTER excelrpt.csv,tmp,h.. (H = comma-delimited fields, with header record containing field names)
You also shouldn't use BREAK. A .csv file should be a flat file were all the records are the same layout - except for the header record. For the same reason you should only have one PRINT statement and no TOTAL. I would also suggest LINES 0.
Since this is going to be opened in a spreadsheet program, they can do sorting, totals, etc on any columns they want using that program.
bb
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.