Symptoms

You export a report to CSV format, but the export file is empty or is missing some lines of data.

Cause

This problem can occur if your report uses group headers and footers. By default, Report Commander does not export headers and footers when you use CSV format.

If your report does not have any fields in the "Details" section but instead uses headers and footers to display data, the export file would be empty, because Report Commander would be pulling only from the Details section.

If you report has fields in the "Details" section and in the headers and footers, the output file would be lacking the lines that come from the headers and footers.

Resolution

Include the following option on the Report Commander command line:

This will cause Report Commander to include all header and footer data.