Operation Manual

whether you want to update the report later. In this case, select dynamic. If you choose static, the
report will always contain the data for the original report date.
LibreOffice has always included the Report Builder extension. For some reason, it does not work in
some versions. For these, creating a report is done the same way as is done using OpenOffice.org
3.3, and the Getting Started with Base chapter for OpenOffice.org 3.3 explains the basics for
creating a report that can be used.
With the report builder extension working, selecting the type of report as static gives only a table
layout of the report's data similar to Figure 258 on page 257. The area above the data can contain
things like the author of the report, its date, and its name. A company logo can be placed there as
well. The area below the data can also contain text and fields such as page number of page count.
Note
Editing a static report will be discussed in Chapter 4 of the Base Guide, Data Output.
When dynamic is selected as the report type and the report builder extension is working, the report
can be edited. Its layout can be in one of two formats: a text document or a spreadsheet. Also, it
can be saved in a variety of formats that are available for Writer and Calc documents.
My recommendation for those that have the report builder extension working in their version of
LibreOffice is that they always select dynamic as the report type. You will have more control over
the layout of the report than if you had selected static instead.
Vacations table report
To create a new report.
1) Click the Reports icon in the Database list in the Automobile – LibreOffice Base window
(Figure 199).
2) In the Tasks list, click Use Wizard to Create Report. The Report Wizard opens.
Tip
When the Report Wizard opens, the Oracle Report Builder opens in the background.
As you perform the steps of the wizard, it applies these steps to the Report Builder.
You will not be directly using the Report Builder in these steps.
Step 1: Field selection
1) Select Table: Vacations in the Tables or Queries drop down list.
2) Use the > to move these fields from the Available fields list to the Fields in report list: Date,
Motel, Tolls, Miscellaneous, Breakfast, Lunch, Supper, and SnackCost. Click Next.
Figure 254: Adding fields to a report
Chapter 8 Getting Started with Base | 255