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:
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 Call Duration, Subject, and Note fields. The report output will look like this:
This report was generated using the Report Renderer (RPTRender) and a connection to the access database using ODBC.
