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

Caution

Dynamic reports update only the data that is changed or added

to a table or query. It does not show any modifications made to

a table or query. For example, open the fuel economy query you

just created. For the "End-Reading".”Odometer –

Fuel.”Odometer” column, change the number 1 to the number 3

after creating the report below. The report will be identical

before and after you make the change.

For example, a report on vacation expenses divided into categories

should probably be a static report because it is based upon specific

data that does not change. However, a report on the fuel data should

probably be a dynamic report, because this report depends upon data

that does change.

Caution

All reports are based upon a single table or query. So you

need first to decide what fields you want to use in the report.

If you want to use fields from different tables, you must first

combine these fields in a single query. Then you can create a

report on this query.

An example of this caution is creating a report on vacation expenses.

Fuel costs are one part of that report as are meal costs. These values

are contained in fields of two different tables: Vacations and Fuel. So

this report requires creating a query.

Creating a static report

We will create a report on vacation expenses. Certain questions need

to be asked before creating the report.

• What information do we want in the report?

• How do we want the information arraigned?

• 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

Chapter 8 Getting Started with Base 299

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

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 299