Our first release this year... We would like to announce a new release of OpenOffice reporting engine for OpenERP.

This release included extensive improvements for pdf conversion and other parts of the code. Now it is possible to run OpenERP and OpenOffice.org on separate systems over network. It means that it is easier to set up working system and employ load balancing. Although it needs more tests to be done on Windows platform, we rewrote some parts of the code to make this system more compatible for Windows installations.

What's new in this release:
* global and local stylesheet support;
* wizard for creating a print buttons;
* improved performance;
* lot of bugs fixed;
* more stable operation;
* stabilized framework;

Where to start:
* source code of this system is being hosted on Launchpad https://launchpad.net/report-openoffice ;
* installation packages can be downloaded from Launchpad https://launchpad.net/report-openoffice/+download or KN dati webpage http://kndati.lv/index.php/web-links/44-open-erp-addons ;
* installation manual at KN dati http://kndati.lv/index.php/en/openerp/open-erp-addons/reporting-engine ;

Note: Those, who tested earlier versions of this module, to perform an upgrade please see this forum thread http://kndati.lv/forum/viewtopic.php?f=11&t=42


Best regards,
Kaspars
-----------------------------------
http://kndati.lv

Last edited by sraps on Sat Jan 23, 2010 8:21 pm; edited 1 time in total

@sraps,

Hello, I would like to praise the initiative. I discovered / tested only yesterday, with the new quick OpenOffice 3.2 RC by the way, and I've been stunned. Wow! How much time did I lost the last years tweaking the official report engine to get a decent layout or even applying RML patches, but with your module it's just a child play, it's fast...

It's so reliable, that you can just do it for any report (we will use them for all our contract and sale documents next week) and you can even at will open them as odt and then manually alter them, and then get your pdf back (you could with the official system, but it was so much work that you would do it only for the main documents, not any document).

Thank you for this module. I think, along with the Kettle + OOOR OpenERP plugin we just made and we are about to blog about, those two new tools, enable you to save a great number of coding/hacking days for the average OpenERP installation. Thanks to your module, my two current customers are likely to save each 3 days of ingrate layouting job, that's a great deal for project smaller than 20 days...
_________________
Raphaël Valyi

CEO and OpenERP consultant at
http://www.akretion.com

HI Kaspars!!

I will try today and tell you. THANK YOU VERY MUCH!!! UserFriendly report engine was really missing functionality on OpenERP,

I only wanted to post the correct link to manuals here:
http://kndati.lv/index.php/en/openerp/open-erp-addons/reporting-engine

You included a semicolon on link and it does not work, but it was easy finding the right one on your site.


Thank you!!!

Ana
_________________
Manuales, Videotutoriales de OpenERP en http://www.openerpsite.com
http://www.aulaerp.com

Hi!
some remarks / questions
http://kndati.lv/index.php/en/openerp/open-erp-addons/reporting-engine/78-first-report
not clear what to do

5 - Save report template to accessible place;
where? server addons module or client for last bullet point of next 4 "Template Content"?

http://kndati.lv/index.php/en/openerp/open-erp-addons/reporting-engine/76-openofficeorg-reporting-engine-installation
Event Type: Client_print_multi
should be (low c)
Event Type: client_print_multi

IMHO does not work on trunk - didn't try yet on 5.0
on opening invoice

Quote:

Traceback (most recent call last): File "/home/gass/OpenERP/trunk/openobject-server/bin/netsvc.py", line 369, in dispatch result = ExportService.getService(service_name).dispatch(method, auth, params) File "/home/gass/OpenERP/trunk/openobject-server/bin/service/web_services.py", line 609, in dispatch res = fn(db, uid, *params) File "/home/gass/OpenERP/trunk/openobject-server/bin/osv/osv.py", line 60, in wrapper return f(self, dbname, *args, **kwargs) File "/home/gass/OpenERP/trunk/openobject-server/bin/osv/osv.py", line 119, in execute res = pool.execute_cr(cr, uid, obj, method, *args, **kw) File "/home/gass/OpenERP/trunk/openobject-server/bin/osv/osv.py", line 111, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/home/gass/OpenERP/trunk/openobject-server/bin/osv/orm.py", line 1456, in fields_view_get resprint = filter(lambda x: not x.get('multi', False), resprint) File "/home/gass/OpenERP/trunk/openobject-server/bin/osv/orm.py", line 1456, in <lambda> resprint = filter(lambda x: not x.get('multi', False), resprint) AttributeError: 'str' object has no attribute 'get'

or did I mess up something ?
thanks

I couldn't install

I think it is something about routes to relatorio libraries, but I'm not able installing even if I have read all posts on forum about my error. It seems to be a common error.

I opened this bug on sraps forum for contribution:

Ubuntu: No module named relatorio.templates.opendocument
http://kndati.lv/forum/viewtopic.php?f=11&t=44

Thank you very much!!!

Ana
_________________
Manuales, Videotutoriales de OpenERP en http://www.openerpsite.com
http://www.aulaerp.com

Hi!
Corrected mistakes in announcement and documentation, this is how it goes when computer thinks for the human.

I am sure there will be many corrections needed, still we will try to do our best, to make it more stable. We would really appreciate your involvement in making module better.

Best regards,
Kaspars
-------------------
http://kndati.lv

after installing report_openoffice (from launchpad on OpenSUSE) and following the description in
http://kndati.lv/index.php/en/openerp/open-erp-addons/reporting-engine/78-first-report

I get an error clicking on the print button for the new report

Quote:

| Traceback (most recent call last): | File "/usr/lib64/python2.5/site-packages/Pyro/protocol.py", line 669, in _handleInvocation2 | res = obj.Pyro_dyncall(req[1],flags,req[3]) # (method,flags,args) | File "/usr/lib64/python2.5/site-packages/Pyro/core.py", line 108, in Pyro_dyncall | return getattr(self.delegate or self,method) (*args,**keywords) | File "/home/terp/OpenERP/branch/server/5.0/bin/addons/pyro.zip/pyro/pyro.py", line 48, in dispatch | result=method(*args) | File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 731, in report_get | return self._check_report(report_id) | File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 707, in _check_report | raise result['exception'] | ExceptionWithTraceback: (u'report.account.invoice.myinvoice', (<type>, KeyError('report.account.invoice.myinvoice',), <traceback>)) +--- End of remote traceback

any other variables or checkboxes to set in Report XML ?


BTW
http://kndati.lv/index.php/en/openerp/open-erp-addons/reporting-engine/76-openofficeorg-reporting-engine-installation
should point to the (1) URL for creating a report - IMHO these 2 URLS do not conform in small details.

thanks

still problems
after installing report_openoffice - all invoice reports raise this error

afetr uninstalling it works again

Quote:

Environment Information : System : Linux-2.6.31.8-0.1-desktop-x86_64-with-SuSE-11.2-x86_64 OS Name : posix LSB Version: core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64:desktop-4.0-amd64:desktop-4.0-noarch:graphics-2.0-amd64:graphics-2.0-noarch:graphics-3.2-amd64:graphics-3.2-noarch:graphics-4.0-amd64:graphics-4.0-noarch Distributor ID: SUSE LINUX Description: openSUSE 11.2 (x86_64) Release: 11.2 Codename: n/a Operating System Release : 2.6.31.8-0.1-desktop Operating System Version : #1 SMP PREEMPT 2009-12-15 23:55:40 +0100 Operating System Architecture : 64bit Operating System Locale : en_US.UTF8 Python Version : 2.6.2 OpenERP-Client Version : 5.0.7 Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last): File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 683, in go (result, format) = obj.create(cr, uid, ids, datas, context) File "/home/terp/OpenERP/branch/server/5.0/bin/report/report_sxw.py", line 364, in create return fnct(cr, uid, ids, data, report_xml, context) File "/home/terp/OpenERP/branch/server/5.0/bin/report/report_sxw.py", line 392, in create_source_pdf result = self.create_single_pdf(cr, uid, [obj.id], data, report_xml, context) File "/home/terp/OpenERP/branch/server/5.0/bin/report/report_sxw.py", line 433, in create_single_pdf processed_rml = self.preprocess_rml(etree.XML(rml),report_xml.report_type) File "lxml.etree.pyx", line 2512, in lxml.etree.XML (src/lxml/lxml.etree.c:48057) File "parser.pxi", line 1542, in lxml.etree._parseMemoryDocument (src/lxml/lxml.etree.c:71774) ValueError: can only parse strings

pls can you tell wich (extra) modules must be available
like to check with python import <modul> to see if all is correctly installed
thank you

(meanwhile I checked, all modules in report_openoffice can be imported)

@ferdinand

It seems that our module is not compatible with server version 5.0.7. Something has changed in server environment. We will look at this problem.

Meanwhile, could you report your errors to Launchpad, naming server an client versions.:
https://bugs.launchpad.net/report-openoffice

Note: at the moment sample report package is not up to date, so it is removed from downloads.

Kaspars
------------------------------
http://kndati.lv

I tested OpenERP server v. 5.0.7 and client on Fedora 9 - works as expected, no apparent problems, although I experienced problems in Ubuntu Server 9.10 and python 2.6.x - it did not work. So should investigate further.

@ferdinand
Make sure you set report type NOT pdf but OpenOffice - pdf output. If you do not set it correctly, then server will use original parser on that odt template and will fail.

P.S. Also there were some errors into current release, they are fixed but still not uploaded in launchpad, will do it on Jan 28.

yep, success here with 5.0.7 too. As I said, even worked with beta OpenOffice 3.2 RC (that's right, we are on the bleeding edge) which is surprisingly the first fast startup OpenOffice ever; something very important for the whole OpenOffice acceptance I think, even if the Oracle shadow on it will not help now...
_________________
Raphaël Valyi

CEO and OpenERP consultant at
http://www.akretion.com

We have updated Launchpad repository to latest codebase (both - bzr branch and package) version. It will probably address several nasty bugs.

Kaspars
---------------------
http://kndati.lv

seems to work very well, thanks a lot, this piece of code was really missing

Question (1):

(How) Is it possible to embed images which are stored in OpenERP like
* res_company.logo or
* 'image' : fields.binary ('Image')

I just get hexadecimal (?) output

Question (2):
how to print a list (mulitple or all lines)
probably a very common need

Quote:

In “Placeholder” field write “objects[0].name”

pints obviously only the first element.

thanks

Last edited by ferdinand on Sat Jan 30, 2010 9:44 pm; edited 1 time in total