CODEWITHSUNDEEP
excelcrystal-reportsexport
Nathan Koop
Nathan Koop

Reputation: 25197

Crystal reports export to excel cell merge issue

When I export from Crystal Reports, any fields that are marked as Can Grow are merged with an otherwise blank row below them.

This completely messes up my sorting. How can I resolve this?

Upvotes: 2

Views: 14448

Answers (2)

Emanuele Greco
Emanuele Greco

Reputation: 12721

I suggest another way: choose ExportFormatType.ExcelRecord instead of ExportFormatType.Excel. The xls file will be created without formatting.

If actually the user is exporting report using ReportViewer Toolbar Export button you can:

  • Replace the CrystalReportViewer Control with the ReportExporter Control. It will export the report in the format you choose.

Or hide Export button from toolbar and put in the page buttons that exports programmatically

CrystalReportSource1.ReportDocument.ExportToHttpResponse(ExportFormatType.ExcelRecord, this.Response , false, "report.xls");

reportDocument.ExportToDisk(ExportFormatType.ExcelRecord, "report.xls");

You can choose the way that best fits your needs, but you must try if it works with the runtime you use either in development or in release server.

ExportFormatType.ExcelRecord means that is generated an xls file, without formatting. If you set ExportFormatType.Excel fields that are marked as "Can Grow" are merged with an otherwise blank row below them.

Upvotes: 3

Ahmed Atia
Ahmed Atia

Reputation: 17960

I always get a lot of problems while exporting crystal report to excel, I always got the same problem you have encountered.
I solved that problem by exporting dataset (report datasource) directly to excel, this solved all the issues, I've encountered.

Please refer to this link for Export a Dataset to Excel.

Upvotes: 2

Related Questions