Export to xlsx in reporting service (crystal report)

  • 14 June 2019
  • 1 reply

Badge +3
We created a report in Crystal Reports which we want to export to xlsx format and not to xls format. Is this possible?

We want to do this because after generating several Excel
files using the Thinkwise reporting Service we want to combine them as separate
worksheets in one excel file. The component we use for this needs to have xlsx and
not xls.

Best answer by Jasper 17 June 2019, 13:53

View original

1 reply

Userlevel 7
Badge +11
Crystal Reports unfortunately only supports exporting the data without styling to Excel 2007 (XLSX). See this link for more info.

An alternative would be to use DevExpress or SQL Server Reporting, which both support exporting to XLSX.