From the mailbag, in response to Exporting to Excel in Crystal Reports .NET – Perfect Excel Exports
Hi, I was searching in the internet about how to solve a problem I have and found your name in an asp alliance article, I left a post there but I prefer to email you.
The problem is this:
Im developing a project with VS 2005 and Crystal Reports, I need to export two reports to Excel but not in just two different xls files but just one with different sheets, if you know how to help me please
Crystal Reports isn’t designed for this. If you want to easily create Excel from data, you need to look into a product like Spreadsheet Gear, OfficeWriter or ActiveXLS. I’ve used the free ExcelXmlWriter with great success.