Collapse AllExpand All

4.1. Loading Reports from a Database

For the purposes of this exercise, we will assume we are connecting to an xTuple database, using the xTuple report writer. However, you would follow similar steps using the standalone OpenRPT application connected to a different database.

To begin with, let’s load an existing report definition into the report writer from an xTuple database. From the Master Information section of the System module, select the Reports option. The master list of report definitions will appear, as shown below:

Master list of Report Definitions in xTuple database

We will be working with an xTuple report definition called UsersMasterList. This is a report which details information about xTuple user accounts. We can load the report definition into the report writer simply by opening it. To open the report definition, double-click on it—or highlight it and then select the EDIT button. The following screen will appear:

Load report definition from database

The UsersMasterList is now loaded into the report writer. Our next step will be to save the report definition to a local drive.