Removing all page breaks from a Crystal Reports 2016 v14 - Excel export

Question

Since I last used Crystal, I have had a client who had a lovely report (with page breaks in all the right places). They really want to export the report to one large Excel file, however, there is a difficulty with that.

We have it set up so that the page header only exports once, but we are unable to prevent recurring group headers from occurring when it seems Crystal thinks the output data should be "page broken."

I can't seem to find a way to "ignore page breaks" in the Excel export or on the detail or page sections. Is there any way to do this?

Answer 1

Try ExportFormatType.ExcelRecord instead of ExportFormatType.Excel. It will not be formatted after that.