Dynamic reports can be updated to show the latest data.įor 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. Static reports contain the data in the selected fields at the time the report was created.

They can contain all of the fields of the table or query or just a selected group of fields. Reports are generated from the database's tables or queries. Reports provide information found in the database in a useful way. It also requires having a copy of the Hsqldb User Guide available from This is how the and operator works on sets. That means that all of these criteria have to be met before a row of values will be created in the query. For example, we listed all of our criteria in one row. To fully use queries requires a knowledge of mathematics and specifically set operations ( unions, intersections, and, or, complements, and any combinations of these). We can include when each album was bought. The information we want is what albums are by a certain musical group or individual (the album's author). The Query Wizard window opens (Figure 66). In the main database window (Figure 2), click the Queries icon in the Databases section, then in the Tasks section, click Use Wizard to Create Query. Queries which require calculations are best created with the Design view.

It is possible to obtain a single answer or multiple answers, depending upon the circumstances. Queries created by the wizard provide a list or lists of information based upon what one wants to know. Top of page Using the Wizard to create a query Query results, themselves, are special tables within the database. Since the query (one part of a database) does this, the data source appears to become one part of that database: its table or tables. However, searching for usable information from a data source requires a query. A database is only one type of data source. Queries blur the differences between a database and a data source.

Group items in query openoffice base