Printing with MS Excel Files

One of the data sources that you can print from is a MS Excel file. Crystal makes it simple to print using the worksheets within a spreadsheet file. It references each worksheet as if it were a table within the data source. However, there are a few quirks that you have to work around to make it function properly.

The most obvious way of printing from an Excel file is to use the Database Expert and go to the category called More Data Sources. Within this category you find an option for connecting to MS Excel via DAO (data access objects). Select this option and then find the Excel file you want to print from. It will list each worksheet that has data on it. Add the worksheets to print from into the Selected Tables window. Once the worksheets have been selected, proceed to design the report as normal.