Configuring Notes/Domino with Crystal Reports

Crystal Reports 8.0 is a great tool for creating professional reports with Notes/Domino data.

Crystal Reports 8.0 is a great tool for creating professional reports with Notes/Domino data. I spent a lot of time fine tuning the performance. Crystal Reports does have a native Notes driver that works fine but the performance is slow. You can create your report using Notes forms or views. Using forms to report on is very slow.

Bottom line: Use the Notes SQL 3.01 driver and Notes views for your data source. After you download the Notes SQL driver from www.lotus.com and install it, you configure it using the ODBC 32-bit program in Windows. Create the views in Notes with your keys being the first columns and including all the fields you will need for your report. In Crystal, use the ODBC source for your data source. From there, you can then create relational joins and layout your report.


Dig Deeper on Domino Resources - Part 3

SearchWindowsServer

Search400

  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

  • HTML cheat sheet

    This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

  • Carol Woodbury: Security

    Carol Woodbury

SearchDataCenter

SearchContentManagement

Close