Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How can I bypass the OpenOffice Report Designer plugin and edit reports directly?

Gilles Lehoux
on 2/17/14, 12:58 PM 1,536 views

Many people have issues with the OpenOffice Report Designer plugin. Assuming one had OpenOffice and direct access to OpenERP's folders and files, how could one open the reports directly for editing? What are the issues with file ownership and permissions? Are there cases where more than one file needs to be edited in order to make a type of change to a report? What is a quick and easy way to get the file name related to a report?

Ideally, it would just be a matter of using sudo, when under unix, and OpenOffice.


Ray Carnes

--Ray Carnes--
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 2/17/14, 6:34 PM

Also check out:


You can edit the RML directly from OpenERP.

image description

Andreas Marpmann
On 2/17/14, 3:28 PM

You can find e.g. the sales_order.rml in addons/sales/report and edit it in a Texteditor.


Gilles Lehoux

--Gilles Lehoux--
| 5 4 7
St-Eustache, Canada
--Gilles Lehoux--

Gilles Lehoux
On 2/17/14, 7:44 PM

There is no way to edit rml in OpenOffice without the plugin. Furthermore, there exists no wysiwyg editor application for rml.

If you open an rml file with OpenOffice then you will see the rml source code. This is the same as opening the file in a plain text editor.

If you are a programmer then all of OpenERP is modifiable using a text editor. If you are a non-programmer and the plugin doesn't work for you (bug) then you can either learn what programming skills you need for the task or hire someone who already does. Either way, it's a large investment if all you want is to change a small thing.

Keep in mind that the rml files are located at the heart of OpenERP. They are not within a database. Sometimes, you can have a dummy database where you can tryout things before applying them in the production database. In the case of the rml files, if you make a change and save it then the change goes live to anyone using OpenERP from then on. If you make the change using a text editor then you will be going by trial and error - make a change, save it, generate a report within OpenERP, make a note of needed changes, start again. Under those conditions, the editing process is significantly longer than with a wysiwyg editor.

Some more information here: http://stackoverflow.com/questions/5247452/does-a-wysiwyg-editor-for-report-labs-rml-exist

On 2/18/14, 1:11 AM

Hi just with your favourite text editor :-)

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)


Asked: 2/17/14, 12:58 PM
Seen: 1536 times
Last updated: 3/16/15, 8:10 AM