The next thing is that there are really two ways to go - you can either do all the sorting and grouping in the report writer or you can prep the data in a query first. ( This is the latest version available at the extensions download site and has a bug in it under 2.4.1, but the patched file should be available very shortly ). In the process, we will be explaining how a database work.To do this I am going to use the SUN Report Builder extension, release 1.0.4. To explain how to use a database, we will create one for automobile expenses. Relationships are defined in terms of unions and intersections of the subsets (tables). The fields of a database are the elements. If you are acquainted with mathematical sets, a relational database can easily be explained in terms of sets: elements, subsets, unions, and intersections. The relationship between the names and social security number is one-to-one: only one social security number for each name. One of the fields contains the names of the employees while others contain the social security numbers, and other personal data. Most if not all the relationships in such a database are one-to-many relationships.Ĭonsider an employment database for the same library. This is what is known as a one-to-many relationship: one author and more than one book. The library may contain more than one book by the same author. There is an obvious relationship between the authors and the books they have written. It will contain a field for the names of the authors and another field for the names of the books. This makes it fairly easy to create a database in which the fields of the database have relationships with each other.įor example: Consider a database for a library.

Windows' version of JRE can not be used, while there are other versions that can.īase creates relational databases. In OOo, use Tools > Options > Java to register Java. If you do not have it on your computer, you can download it fromĪnd install it following the instructions on the site. The database in OOo requires Java Runtime Environment (JRE).

Group items in query openoffice base