Odoo Help


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

Gilles Lehoux
on 2/17/14, 12:58 PM 2,115 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
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

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. 

I am a skilled Communicator and I only take the serious things seriously!

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 8
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 :-)

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


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