A Huge Printable PDF Article on Advanced OpenOffice.org Report Techniques, Including SQL-Based Calculated Fields on Reports and Using the Next Record field (Repost)

I decided to repost this since it's got lots of really fun powerful NOT obvious technical stuff for reports.

---------------------------------------------------------------------

Here's the TOC.

A Quick Review of the Report Writer Tool

What You Can Do in the Query Design Tool and SQL View

What You Can Do With Report-Specific Fields

Quick-and-Dirty Reports

Creating Your Own Reports Using the Next Record Field

Powerful Reports Can Be Fun....If You Enjoy Getting Your Hands Dirty

 

Here's the link. It's a big PDF.

---

---

Comments

[lindner bernard]

I just discover your sympathetic site and I wonder if you can help me about a simple database I have try to make it working for hours without any success ?
Thank you for reply
As I am writting from Strasbourg in France will you excuse mistakes in writting

[Andres Cabrera]

Hi,
Thanks for the blog. Absolutely amazing!
I just wanted to point out that multiplication of fields in a database as you explain doesn't seem to be working. The procedure can be done as you explain and the fields pare placed between quotes, but generating the report produces an empty column.
This is on Ubuntu 8.04 and OpenOffice 2.4.

Cheers,
Andrés