Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

13.19 MS Excel Files

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 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.

At this point, if you run your program and try to print the report, a Database Login dialog box appears. It is asking you to enter the user credentials for the Excel spreadsheet. Of course, there are no user credentials to enter so you just click on Finish. This...

Get UNLIMITED Crystal Reports Online Training!

Click Here To Start Your Training!

1500+ Tutorial Pages

Complete Crystal Reports Online Training with over 1,500 pages of better than book quality Crystal Reports tutorials.

Step-by-step Online Videos

Learn at your own pace from the comfort of your home! Pause, rewind and watch online training videos anytime!

Online Community

Members-only community where you can post and answer questions. The community is checked on a regular basis by best selling Crystal Reports book author Brian Bischof to help answer your questions.

Cut & Paste Source Code

Save time with simple cut and paste source code you can use right now in your next report!

Click Here To Start Your Training!