Ask Your Question

How to edit report in openerp 7

asked 2013-03-11 21:57:44 +0200

Benoy P P gravatar image Benoy P P flag of India
101 4 6 13

updated 2013-03-11 21:59:40 +0200

Hi, I would like to make some changes in the layout of Sales Order report (Quotation / Order) , could anyone please guide me how to do it ?Please specify any links for support, if possible.

Regards Benoy

delete close flag offensive retag edit


Can anyone tell me if we can have the sum of a field/column at the end of report like if i have a list of invoices and at the end i can have sum of amount_total at the end? Openoffice? Tried expressions too but no result. pls help

evon ( 2013-06-19 08:42:30 +0200 )edit

4 Answers

Sort by » oldest newest most voted

answered 2013-03-12 00:06:45 +0200

Anas Taji gravatar image Anas Taji flag of Jordan
1299 4 12 28

updated 2013-03-12 00:08:12 +0200

Follow these steps:

  1. You need to have the openERP Report Designer installed into your current database(module name:OpenOffice Report Designer - base_report_designer)

  2. Install the plugin provided by the module into LibreOffice/OpenOffice from Tools->Extension Manager, restart the office suit.

  3. A new menu should appear 'OpenERP Report Designer', Connect to the current database by clicking on 'Server Parameters'.

  4. After that you can create a new report or modify existing one.

  5. Click on 'Modify Existing Report' under 'OpenERP Report Designer' then choose the desired report.

  6. Make changes, then click on 'Convert Fields->Brackets' under 'OpenERP Report Designer', then click on 'Send to the server'.

Hope this helps..%

link publish delete flag offensive edit



Hi!, How can I install the OpenOffice Report Designer. I'm using version 7 and when I try to install from OpenERP APP i get this: The base_report_designer module appears to be unavailable at the moment, please try again later.

Yair García ( 2013-04-19 02:20:59 +0200 )edit

I hope you can help me.

Yair García ( 2013-04-19 02:21:54 +0200 )edit

It seems you are using openERP 7.0 on windows. I think you should wait for a while.%

Anas Taji ( 2013-04-20 01:02:16 +0200 )edit

Hello,i did that very well with OpenERP 6.1 in the past. Now with an online version of OpenERP, the layout does not change when i print my page from OpenERP. Changing colors for example have no impact. if I insert a bad variable, it 'crashes' when i try to print. When i click "Modify an existing report" again, i can see my changes in the download file. Anyone knows why it has no impact when printing the invoice ? Thanks!

Xavier Sand ( 2013-06-12 21:08:47 +0200 )edit

answered 2013-03-12 05:38:26 +0200

chanmyay gravatar image chanmyay

You need to edit in the source file. file location is bin>addons>sale>report> sale_order.rml file you can edit it as you like. Before you edit it, you should copy that rml file.

link publish delete flag offensive edit

answered 2013-04-25 10:09:26 +0200

Szabolcs Szilárd gravatar image Szabolcs Szilárd
1 1

I use openerp7 on win7 on same machine. I installed openerpreportdesigner on openoffice. The openerp menu appeared in the menus. I can not connect to the openerp server. The error mesage is: Group not found.

link publish delete flag offensive edit


are you typing in the correct address eg the default is "localhost" but in my case its should be the server (or whatever yours is!)

Cameron ( 2013-04-28 21:18:07 +0200 )edit

Yes, i have tried it so as well. The server and the client are the same machine. I installed the base_report_designer into OpenOffice, it doesen't work at all. I installed openerp_report_designer, it asks the login data's , but does nothing.

Szabolcs Szilárd ( 2013-04-29 08:44:32 +0200 )edit

answered 2013-03-12 03:49:20 +0200

Juan Miguel Samano gravatar image Juan Miguel Samano
87 1 2 7

which is the username ?? i´m using my username to acces openerp also is the same username to acces database, but when i try to acces in open office openerp extension, i got an error that my login and password are wrong, but i´m entering correct ones

link publish delete flag offensive edit


The user name and password which is specified in the openerp-server.conf file.

Benoy P P ( 2013-03-12 17:48:49 +0200 )edit

I´m really new, where can i find out openerp-server.conf file ??

Juan Miguel Samano ( 2013-03-13 04:43:24 +0200 )edit

Hi, I have installed the openerp v7 server, on my ubuntu linux machine under /opt/openerp/server folder, so the configuration file is located in "/opt/openerp/server/install/". If you are not using linux, you may search the file name on your computer with openerp-server.conf .

Benoy P P ( 2013-03-13 20:51:05 +0200 )edit

This is not an answer. It's another question. Please post it under the answer you're referring to.

Kevin Shenk ( 2013-04-03 15:49:54 +0200 )edit

Login/Signup to Answer


You can download ebooks on Facebook or buy paper book

You can read the online documentation

Question tools


subscribe to rss feed


Asked: 2013-03-11 21:57:44 +0200

Seen: 7,584 times

Last updated: Apr 25 '13