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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close