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.
My first DotNetSlackers article has been published: Review: SQL Server Integration Services Using Visual Studio 2005 â€“ A Beginners Guide.
Occasionally in life, the right thing shows up at the right time. I was just ready to start some work in SQL Server Integration Services, and like a lot of DTS developers, my mind was boggled when I first opened the SSIS workbench. My tasks looked daunting.
That same week, I received an email from Packt Publishing asking if I’d like to review this book. Oh boy would I! Long story short, this book was a significant help in my project. I went from being an overwhelmed DTS guy to a pretty fair SSIS developer in a short period of time. Check out the review for more about the book.
Like the other Packt books I’ve read, it’s an easy read, partly because of the writing style and partly because of the typography. I don’t know how much time they spent researching the font style, kerning, etc., but their printed materials are easy on the eyes. There are a lot of screenshots in the hands-on chapters, and being a beginner’s guide, background information on using the relevant parts of VS 2005 is included. There are no major changes to SSIS in SQL Server 2008, so this book will be relevant for a while.
Get it at Amazon: SQL Server Integration Services Using Visual Studio 2005 â€“ A Beginners Guide