Odoo Help


Modify OpenErp7 Reports

umer farooq
on 11/7/13, 12:32 PM 2,331 views


I want my general ledger to be customized a bit i need to add a column and just want to make it according to my office requirements.I read about openoffice and some other ways to modify and customize reports but not found any solution very much concrete.and i am also confused about .sxw .rml conversion like what to do where to go and where to change the things. can anybody please tell me or give me the link of tutorial that helps me to learn modification and little bit development wherever it will be required.please guide i will be very grateful.Detailed answer would be appreciated because i am learning it right now:)

Tutorial is required which is easily understandable.Thank you..

umer farooq
on 11/8/13, 12:32 PM
Pavel Pavlov
On 11/11/13, 7:32 AM


It's pretty simple
1) Download and install Apache Open Office 3.4 or lower.
2) Go to your openERP -> Settings -> Apps -> Find OpenOffice Report Designer(base_report_designer) and follow the instructions there. It will give you link to a archive with Open Office plugin that you have to install in your Open Office. The plugin has instructions how it should be done.
3) After you've done 1 & 2 go to Open Office Writer -> From main menu OpenERP Report Designer -> Connect to server
4) When you are connected to your openERP server from Open Office you can use "Modify existing report" and open the report you need...

Pavel Pavlov

Pavel Pavolv thanks for your answer.but i am using openoffice 3.4.1 and when i click to openerp report designer and on server parameters it doesn't response please help me in this why is it happening ?

umer farooq
on 11/11/13, 10:26 AM

Hi, this is for sure not normal. What OS are you using? What version of openERP? I had simillar problem with Debian + openERP 8(trunk), but then I rolled back to Windows + v7 and it was not happening any more...

Pavel Pavlov
on 11/11/13, 4:15 PM

I restarted and it worked fine for me thank you :)

umer farooq
on 11/12/13, 9:40 AM

Gopakumar N G

--Gopakumar N G--
| 5 4 7
Cochin, India
--Gopakumar N G--

Project Lead at Bizweaver Technologies Pvt. Ltd.

Gopakumar N G
On 11/8/13, 3:35 AM

Visit the links.

Jasper Reports


For converting an SXW to RML do the following

Open a terminal, then Navigate to the report folder in your module and execute the following:

gopakumar@gopakumar-desktop:~/Workspace/Project/openerp/addons/module_name/report$ python openerp_sxw2rml.py name_of_sxw_file.sxw > name_of_rml_2b_generated.rml

Before this you have to copy the openerp_sxw2rml.py file from module /base_report_designer/openerp_sxw2rml to your module's report folder.

Check the following for more on Jasper Reports Jasper Reports

Thanks Brother Gopakumar for you response but can't I edit reports in Drag Drop window like what i need i edit it and saved it.I am not a technical person :( that's why it would be little annoying for you but if i can get any tutorial that teaches me step by step would be highly helpful and I will be very grateful to you:)

umer farooq
on 11/8/13, 12:31 PM

Check the answer now, I have updated.

Gopakumar N G
on 11/11/13, 5:58 AM

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

0 follower(s)


Asked: 11/7/13, 12:32 PM
Seen: 2331 times
Last updated: 3/16/15, 8:10 AM