All the Columns are not displayed in the excel report through crystal reports JAVA SDK.

[former_member326756]

When generating the crystal report in excel format through JAVA SDK , all the columns are not getting displayed . There are total 64 columns in the report but only 53 columns are displayed in the excel , it is working fine in PDF and CSV format . All the columns are displayed when the report is generated from crystal reports tool. Below is the SDK code used to generate the report.

ReportClientDocument reportClientDocument = new ReportClientDocument(); reportClientDocument.setReportAppServer(ReportClientDocument.inprocConnectionString);

reportPath = request.getParameter("report_path");

reportClientDocument.open(reportPath, OpenReportOptions._openAsReadOnly); byteArrayInputStream = (ByteArrayInputStream) reportClientDocument .getPrintOutputController().export(ReportExportFormat.recordToMSExcel);

If needed any details let us know.

[former_member203619]

An issue like this is usually extremely report specific. Without seeing the report my recommendation would be to check the spacing and alignment of the columns in the report. Try removing all the other columns except for the ones that aren't exporting correctly and see if they export properly then. You will likely need to play around with the alignment and spacing of the columns in the report.

Note: Are the missing columns in a subreport?

Shawn