This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new Linux.com!

Linux.com

Feature: Office Software

Sun Report Builder: Better reporting in OpenOffice.org

By Dmitri Popov on October 19, 2007 (4:00:00 PM)

Share    Print    Comments   

OpenOffice.org Base is undoubtedly a powerful database application, but when it comes to its built-in reporting engine, words like "underpowered" and "outdated" come to mind. Fortunately, you don't have to put up with this situation any longer: with the Sun Report Builder (SRB) extension, you can add nifty reporting features based on Pentaho reporting engine -- assuming you can figure out how to use it without any help.

Pentaho develops top-notch open source business intelligence and reporting tools. The new Report Builder is the first fruit of a collaboration between Sun and Pentaho announced a few months ago. While the first incarnation of the report builder is not as powerful as Pentaho's own reporting tools, it's still a huge improvement over the existing reporting feature. The only fly in the ointment is that Sun Report Builder works only with OpenOffice.org 2.3 or higher, so users of older versions must upgrade the office suite to take advantage of the new tool.

Since SRB is distributed as an .oxt package, you can install it as a conventional OpenOffice.org extension. To do this, download the latest sun-report-builder_x.x.x.oxt package, launch OpenOffice.org, and choose Tools -> Extension Manager. Select the My Extensions section and press the Add button. Select the downloaded extension, press OK, and restart OpenOffice.org.

Unlike other extensions, SRB doesn't add any menu items: instead, it integrates directly into OpenOffice.org Base. To open the report builder, you have to switch to the Reports section in the Base main window, and click the Create Report in Design View link.

SRB looks and acts a lot like Base's Form Builder, so if you've created forms before, you will quickly figure out SRB's interface and basic features. By default, the blank report window is divided into three sections: Page Header, Detail, and Page Footer. The header and footer sections are usually used for things like report name, date, and page count. The dynamic content pulled by the report from the database goes in the Detail section. The Properties window to the left shows all the options that are available for the currently selected element in the report, while the Report Controls and other toolbars give quick access to report design tools.

To design a report, you add fields to the appropriate page sections and specify their properties. Before you can add any field, however, you have to specify which table the report should use. Press the Report Navigator button in the Main toolbar (or press F5) and select the top Report item. In the Properties window, switch to the Data tab, select Table from the Content type drop-down list, then select the table you want to use from the Content list.

To add a field to the report, press the appropriate button on the Report Controls toolbar (e.g. Text Box), and draw a field where you want it to appear. Under the Data tab in the Properties window, select the desired data field, and you are done.

Sorting and grouping the data in a report are equally straightforward. Choose View Sorting and Grouping, select the field you want to use as a group or sort key, and specify the available properties. When you add sorting or grouping criteria, SRB inserts a new page header where you can add the desired grouping or sorting title.

Besides simple text fields, SRB allows you to create calculation fields called functions. To create a function, right-click on the Function item in the Report Navigator and choose New Function. Specify the calculation you want in the Formula field in the Properties window and enter the function's name in the Name field. You can then bind the created function to a field in the report.

While creating functions is not particularly complicated, the difficult part is figuring out how exactly to write formulas. SRB comes without any documentation, so what operators and formats are supported is still a mystery.

This is, indeed, the weakest point of the current release of SRB. Obviously, it sports a few clever features, but the complete lack of online help or any kind of documentation renders them virtually useless. The SRB wiki contains a few initial notes, but they cannot be considered documentation by any stretch of imagination.

All in all, Sun has done a commendable job with the first release of the reporting tool, but until the software is appropriately documented, most of its advanced features will leave average users scratching their heads.

Dmitri Popov is a freelance writer whose articles have appeared in Russian, British, US, German, and Danish computer magazines.

Share    Print    Comments   

Comments

on Sun Report Builder: Better reporting in OpenOffice.org

Note: Comments are owned by the poster. We are not responsible for their content.

tell a phone

Posted by: Anonymous [ip: 66.122.165.195] on October 19, 2007 09:24 PM
How about a usb, (dongle, connector), that has a telephone hardware jack on the opposite end (rs 22 ? ). This would allow a PC (Eee PC) with telephone software to answere calls as a telephone, allowing the PC to be used as a note pad to keep notes about the conversation (report) and e-mail, or fax them if neccessary over the internet. By providing duo I/O the PC could make phone calls or send email as a security gateway (using the alternate I/O channel to flag or send or recieve accept or reply athority). Programs that allow key board or phone pad text input could be searched for key words to forward important mesages. The usb connection and internet connectability could interface with CB, walky-talky, blue tooth technowledgy for local reporting, or ham radio for non-commercial communication. (call home on your radio and send a text or voice mesage)

#

Sun Report Builder: Better reporting in OpenOffice.org

Posted by: Anonymous [ip: 71.131.180.11] on October 19, 2007 09:41 PM
Sigh.

When are developers going to realize that a product without any documentation is WORTHLESS?

Is it going to kill you to write a few pages of help screen or manual to show how to use the damn thing?

This is just pathetic.

#

Re: Sun Report Builder: Better reporting in OpenOffice.org

Posted by: Anonymous [ip: 68.21.46.169] on October 20, 2007 11:25 AM
Quit being so arrogant! Get off your butt and donate some time to the project to write a basic howto or whatever.

#

Re(1): Sun Report Builder: Better reporting in OpenOffice.org

Posted by: Anonymous [ip: 75.85.41.251] on October 29, 2007 10:31 AM
Quit being so dense and unreasonable! How is someone supposed to write a basic howto or whatever if there is no information available to make it possible? When an application is first developed, the only people who know what it does in detail and how, are the developers. It should be their responsibility to create the first formal low level documentation and/or the built in help so that others can then create higher level HowTo's for specific activities. Sure, it may be possible for someone with a lot of knowledge about the general application field to muck their way through using trial and error to figure things out, but it would be so much more efficient for a few of the developers to provide some basic information to the hundreds of people trying to do that. A few people saving hundreds or thousands of people extra work that should be unnecessary, isn't that worth the trouble? Some delay in increasing the feature count is well worth having the current features made much more usable, sooner.

#

Sun Report Builder: Better reporting in OpenOffice.org

Posted by: Anonymous [ip: 98.207.80.255] on October 28, 2007 03:16 AM
How about a usb, (dongle, connector), that has a telephone hardware jack on the opposite end (rs 22 ? ). This would allow a PC (Eee PC) with telephone software to answere calls as a telephone, allowing the PC to be used as a note pad to keep notes about the conversation (report) and e-mail, or fax them if neccessary over the internet.

Or, how about a usb flash drive which would accomplish pretty much the same data recording capability.
cheers. <a href="www.officialares.com">John Ares</a>

#

Sun Report Builder: Better reporting in OpenOffice.org

Posted by: Anonymous [ip: 98.207.80.255] on October 28, 2007 03:20 AM
How about a usb, (dongle, connector), that has a telephone hardware jack on the opposite end (rs 22 ? ). This would allow a PC (Eee PC) with telephone software to answere calls as a telephone, allowing the PC to be used as a note pad to keep notes about the conversation (report) and e-mail, or fax them if neccessary over the internet. Or, how about a usb flash drive which would accomplish pretty much the same data recording capability. cheers.<a href="http://www.officialares.com">John Ares</a>

#

maybe it can help you

Posted by: Jen on October 31, 2007 02:02 AM
I found http://www.boxsweeper.com has a lot of movies anime music and games!This website is quite great! And it's free for you to streaming and download! Check it out and enjoy it! It will save you much time and money! Don't forgot to thanks me........ha ha

#

Sun Report Builder: Better reporting in OpenOffice.org

Posted by: Anonymous [ip: 209.130.202.190] on December 06, 2007 07:17 PM
Has anyone figured been able to use the Conditional Printing feature?
I need a simple example to understand how to use it.

#

This story has been archived. Comments can no longer be posted.



 
Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya