Creating a new report in OpenERP with the OpenOffice.org report designer

Creating a new OpenERP report with the OpenOffice.org (OOo) report designer isn't very hard, provided you know the right steps to get started. I'm assuming you have the base_report_designer module installed in your OpenERP setup.


  1. In OOo, open a new document.
  2. Connect to your OpenERP server:

    1. OpenERP Report Designer -> Server Parameters
    2. Use the 'Change' button to enter the Server URL parameters
    3. Enter your database, login and password
    4. Click Connect

  3. In the OpenERP Report Designer menu, choose "Open a new report"
  4. You'll be given a list of objects to choose from - choose the one you want your report to be about
  5. Add a loop (either via the menu or via the toolbar, which can be enabled via View -> Toolbars -> Add-On 1). If all is well, you'll have a single object to choose from. This loop needs to be in your document to ensure that you can add the sub-fields of your chosen object to the report.
  6. You can now add fields, layout, everything you like to your report. Don't forget to save your work every now and then. Use the "Send to the server" option in the OpenERP Report Designer menu to upload your report to your OpenERP server. It will be available immediately.


This procedure was tested on OpenERP v.6.0.2

OpenSolaris experiments

I'm experimenting with OpenSolaris in a virtual machine in order to get some more hands-on experience with Crossbow, Containers, ...

Just to make sure : this is not a guide / how-to. These are notes to remind myself of what I did. If you mess up your system by doing anything described here, that's your problem. If I mess up my system ... well ... I have a backup ;-)

First of all : BFU (aka Blindingly Fast Upgrade)

I got BFU from here : http://dlc.sun.com/osol/on/downloads/current/ (it's the SUNWonbld.i386.tar.bz2 file, for i386 in my case)
Then download the Crossbow bits from here : www.opensolaris.org/os/project/crossbow/snapshots/
Extract the BFU archive and install it (after removing any possible older version via pkgrm) :
pkgadd -d . SUNWonbld
Add BFU to the path via ~/.profile :
export PATH=/opt/onbld/bin:/opt/onbld/bin/i386:$PATH
export FASTFS=/opt/onbld/bin/i386/fastfs
export BFULD=/opt/onbld/bin/i386/bfuld
export GZIPBIN=/usr/bin/gzip

Source your .profile again or re-login, extract the crossbow bits and get bfu running:
bfu /rpool/crossbow/nightly-nd
When all is done and you end up in ksh, don't forget to run the Automatic Conflict Resolution script :
/opt/onbld/bin/acr
There you go ... reboot, admire your new GRUB entry and enjoy Crossbow!

Emacs blocks

Even though I've grown to love vim, I'm still an emacs fan. The advantage is that I can now use both equally fluently :-)

One thing I've always found vim to be superior for is inserting blocks of text. No more, for I have learned how to do this in Emacs as well *insert maniacal cackle here*

Select an area in the usual way : press Ctrl-Space to mark the starting point, then navigate to the endpoint (via the arrow keys or Ctrl-n, Ctrl-p, Ctrl-f, Ctrl-b, and the various Meta-key combinations). Once you're satisfied, press Ctrl-x r t and type the text you want to enter into the block, followed by an Enter.

If you've selected one or more columns, the text will replace your selection.

If you haven't selected any columns, the text will simply be inserted.

Another trick (for quickly commenting out several lines of code) is selecting the lines you want to comment, and use

M-x comment-region

w00t!