I am creating a crystal report in VB 2008 which generate a MS Access file in the Crystal Report Viewer, and i want to export my work in crystal report viewer as excel file. Can this be possible???
Vb.net – Crystal Report exporting a report as excel file
crystal-reportsvb.net
Best Answer
I agree with @Andrew about the MS Access file, that doesn't quite make sense. Here is some sample code that shows how to export a report as an .xls file. The code is (obviously) assigned to a button.
You do know that the CrystalReportViewer has a toolbar with an export button, which can export to Excel without the need of any extra code. You can enable/disable that button in the CrystalReportViewer properties or using code like: