Problems and Solutions for Excel export in Crystal Report

Crystal Report is used in recent projects to export Excel files, and the user has high requirements on the Excel format. The following are our solutions:

1. Lines and wireframes cannot be exported. In the crystal report, even if you draw line or box, you cannot see it after being imported into an Excel file. The solution is to use the border of the text field instead of the line or frame.
2. Cell dislocation. When the textfield in the header and detail are not fully aligned, some cells may be misplaced after being imported into an Excel file. The solution is to ensure that the textfield width in the header and detail are consistent, and it is best to leave no gaps before the text field. Horizontal text fields must also be highly consistent, so that similar problems will not be encountered when imported into excel.
3. Modify the legend Text of the chart. To modify the legend of a chart, you must first have a complete crystal report designer, which cannot be changed in the CR integrated by. In crystal report designer, the legend text can be changed only when the report is previewed. The modified rpt file can be used elsewhere, the modified legend text is displayed when you run it again.
4. Page size issues. For example, when an A4 paper is designed in the Crystal Report and exported to an Excel file, the preview is printed directly. Some fields on the right of the page often exceed the width of the page. There is no good solution to this problem. A work und is to leave a space on the right of the paper during design, however, if you want to export PDF files at the same time, it will not look good.

 

In general, it seems that Crystal Report does not support Excel export well. If you have high requirements on the Excel format, it may not be suitable for using crystal report. We used the latest crystal report designer 2008 and didn't see any improvement in Excel support. In addition, compared with vs integration, independent designer has a significant advantage in that many parts of the chart can be tuned, and Cr integrated in vs has been castrated with the functions supported by the chart. Nothing else is too different.