Language Selection

English French German Italian Portuguese Spanish

Creating Reports in OpenOffice.org Base

Filed under
OOo
HowTos

Let's face it, databases are only minimally human-readable. Or, at least, that's the case in OpenOffice.org Base, regardless of whether you view a database's tables directly or filter them through a query or form. In fact, to anybody who's not an accountant or a computer geek, reading databases can be downright intimidating. 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.

By the standards of other databases, such as MySQL or Oracle, Base has a limited report capacity. The designs of its reports are simple and not overly attractive. 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.

Creating a Report

To create a report. 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. If necessary, you can click the Help button for more information about the steps, although be warned that the help is not very detailed.

rest here




More in Tux Machines

Meaning of Convergence, Exploit Excludes Linux

The big news yesterday and even into today was the new Ubuntu tablet, which everyone including Canonical touted as "convergence delivered." Well, today Randall Ross scolds news sites for missing the "timely idea" that is convergence. In other news, security researchers have identified a new exploit that specifically avoids Linux. FOSS Force found that Linux users have no interest in anti-virus software and Phoronix reports on Ubuntu performance over the years. Read more

Tor Browser 5.5.1 Brings a Functional Private Anonymous Browser to Chinese Users

The Tor Project announced today, February 5, 2016, the immediate availability for download of the first point release for the Tor Browser 5.5 anonymous web browser for Linux, Mac OS X, and Microsoft Windows platforms. Read more

Ubuntu Linux in the Wild: How a French University Uses Unity

Is Canonical's Unity interface for Ubuntu Linux ready for use by the masses? Arguably, no. But the administration of the Ecole normale supérieure (ENS) in Paris apparently likes Unity well enough to deploy it throughout the university's library. The ENS is one of France's "grandes écoles," or elite universities. It also happens to have one of the only open-stack academic libraries in Paris, which is what brought me there this week. I was surprised upon entering to find that the workstations throughout the library now run Ubuntu (which was not the case when I was last there, circa early 2012). Here's proof: Read more

The trials of certifying open source software

Open source won and, over the past five years or so, we have been seeing the acceleration of a new wave of open source projects that got their starts in corporations. This comes with a set of new challenges, as new corporate participants struggle with some of the realities. Folks generally understand that foundations provide neutrality in some form, but don't necessarily know how to drive the competitive discussions from the room. One of the more disturbing symptoms of this confusion is the discussions beginning around "certification" and what it means to be certified to a particular project. What is Certified Good SoftwareTM? [1] Read more