OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 300)

100

101

from to pay the expenses.) At the present time, using the data from the

queries in a spreadsheet is the best way to handle reports like this. In

the near future, the report feature will include these abilities.

For our purposes, we will create two reports. The first one will list the

expenses each day other than fuel. The second report will list the fuel

costs each day.

The fields we will 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 fuel was purchased

and entered into this table at times other than during the vacation, a

query needs to be created that contains only the fuel purchased during

the vacation.

Vacations table report

1) Create a new report.

a) Click the

Reports

icon in the Database list in the Automobile –

OpenOffice.org window.

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

Report Wizard window opens.

2) Select the fields.

a) Select Table: Vacations in the Tables or Queries dropdown list.

b) 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 260). Click

Next.

Figure 260: Adding fields to a report

3) Label the fields: answering the question How do you want to label

the fields.

300 Getting Started with OpenOffice.org 3

1 2 ... 295 296 297 298 299 300 301 302 303 304 305 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 300

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0