TomSalvato
Technical User
Hi experts,
I'm trying to export a crystal report (using CR2013) using the 'Microsoft Excel (97-2003)' option. Unfortunately, I have a column for every day of the year, and a couple more. The export stops on column 256 (IV). This is because crystal automatically exports to an XLS file, instead of XLSX. I can export bare bones versions of this report using the 'Microsoft Excel Workbook Data-Only' option, but it's just not as clean. Is there any way to get crystal to export to an xlsx using the first option?
Appreciate any help, I've spent a lot of time on this report, and will be really disappointed if I can't get the proper output after all this. -TS
I'm trying to export a crystal report (using CR2013) using the 'Microsoft Excel (97-2003)' option. Unfortunately, I have a column for every day of the year, and a couple more. The export stops on column 256 (IV). This is because crystal automatically exports to an XLS file, instead of XLSX. I can export bare bones versions of this report using the 'Microsoft Excel Workbook Data-Only' option, but it's just not as clean. Is there any way to get crystal to export to an xlsx using the first option?
Appreciate any help, I've spent a lot of time on this report, and will be really disappointed if I can't get the proper output after all this. -TS