An Access database was chosen to demonstrate the ODBC connectivity capability of OpenRPT because it is widely used and easy to understand. The Contacts database used in the example is in fact one of the sample databases delivered with Access 2000. Below we see two of the tables we will be accessing throughout the example in this chapter:

Contacts and Calls Tables in Sample Access Database

We will generate a report that connects to the Access database through ODBC, performs a SQL query that joins these two tables grouping all calls by caller, and displays each call’s duration, subject, and notes fields. The report output will look like this:

Sample Report Generated with Report Renderer

This report was generated using the Report Renderer (RPTRender) and a connection to the Access database using ODBC.