Creating LibreOffice Base Reports from Multi-table Queries

When you want to build a LibreOffice Base Report sourced from two or more tables, you must use the Query in Design mode to select all the required tables.

If this is not done, when it comes time to design the database report, LibreOffice will allow you to select exclusively one table or another, but not more than one at a time.

For example, two tables in a cheque register database application:

Table 1 contains a list of Payees and their contact info
Table 2 contains a list of Cheques and details about each

In Query Design mode, select all required fields in Table 1 (Payees), then select all required fields in Table 2 (Cheques).

Each column in the Design window will be available to you in the Report Builder later on.