OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 303)

• How do we want the information arranged?

• What fields are required to provide this information?

• Will a query have to be created because these fields are in

different tables?

• Are there any calculations required in the data before being

added to the report?

The expenses for our vacation are motel, tolls, miscellaneous,

breakfast, lunch, supper, snacks, and fuel. One possible report would

simply list the totals of each of these expense groups. Another possible

report would list the expense totals for each day of the vacation. A

third possible report would list the totals for each expense group for

each type of payment. (This would let us know where the money came

from to pay the expenses.) The best way to create reports like these is

to create the queries needed to gather the needed data, insert the

query data into a spreadsheet, and use the necessary Calc functions on

this data.

We will create two reports, one listing the expenses each day other

than fuel and the second listing the fuel costs each day.

The fields we need for the first report from the Vacations table are:

Date, Motel, Toll, Breakfast, Lunch, Supper, SnackCost, and

Miscellaneous. This report will not require an additional query.

The second report involves the Fuel table. Since this table includes fuel

purchases at times other than during the vacation, we need to create a

query that contains only the fuel purchased during the vacation.

Vacations table report

To create a new report.

1) Click the Reports icon in the Database list in the Automobile –

OpenOffice.org Base window (Figure 183).

2) In the Tasks list, click Use Wizard to Create Report. The Report

Wizard opens.

Step 1: Field selection

1) Select Table: Vacations in the Tables or Queries dropdown 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 (Figure 244). Click Next.

Chapter 8 Getting Started with Base 303

Free eBook Edition

1 2 ... 298 299 300 301 302 303 304 305 306 307 308 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 303