

For example, you might want to change a field called CompanyName to simply "Company" or to add a space between the words in a field called LastName. This page is not strictly necessary, but it gives you a chance to display the fields on the report in a more human-friendly way. You can use the left and right arrows to move highlighted fields from one pane to another, and the up and down arrows to reposition fields in the Fields in report pane.Ĭlicking the Next button moves you to the Labelling fields page. Choose the fields to include by moving them from the Available Fields pane to the Fields in report pane. This selection affects the available fields for the report.

The first step in creating a report is to select the table or query from which the report borrows its data. You also might be able to create a query that will add the statistics you want. You cannot use the wizard to run statistics on the data in the report, although with a little patience you can add a few basic ones to the report. If necessary, you can click the Help button for more information about the steps, although be warned that the help is not very detailed.įor that matter, nothing in Base or the on-line help makes clear exactly what you are doing in the wizard-namely, creating a layout to display existing data. open a database and select Reports from the Database pane, then Use Wizard to Create Report, and follow the steps outlined in the Report Wizard. However, this limitation is partially compensated by the fact that reports in Base are quick and easy to create and are displayed and printed in Writer, which gives you tools to improve their layout. The designs of its reports are simple and not overly attractive.

Reports are an effort to manipulate database records into a more friendly form, including preparing them for printing or for insertion into a larger document.īy the standards of other databases, such as MySQL or Oracle, Base has a limited report capacity. In fact, to anybody who's not an accountant or a computer geek, reading databases can be downright intimidating. Or, at least, that's the case in Base, regardless of whether you view a database's tables directly or filter them through a query or form. Let's face it, databases are only minimally human-readable.
