Odoo Help

Welcome!

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.

0

report designer problem

By
Pavel Pavlov
on 9/22/13, 5:00 PM 2,288 views

Hello,

I have problem with the openERP Report Designer... I've followed the steps below and I get "Failed to evaluate expression [[ (picking.address_id and picking.address_id.partner_id and picking.address_id.partner_id.title.name) or '' ]]"
What could be the reason?
Where should I look for the problem - Libre Office plugin problem or openERP problem? EDIT: Just tried upgrading to Libre Office 4 and now the plugin installs, but doesn't work at all..has someone tried using the Report Designer with Debian + KDE + Libre Office 4? For me it doesn't work at all?

Regards,

Pavel

1) Created new empty DB
2) Install OpenOffice Report Designer Latest Version 8.0.0.1
3) Tested Open Office to openERP Connection - OK
4) Install Warehouse Management 8.0.1.1, so that I can get the report I need
5) Create dummy Delivery Order
6) Print the order (everything is there) - img819.imageshack.us/img819/7277/jr9y.png
7) Open the report via Libre Office 3.5.4.2.
Report Designer -> Modify Existing Report -> Delivery Slip
8) Then without changing anything, I just send it back to the server - img826.imageshack.us/img826/2830/f5vr.png
9) Print it again and the address is no longer there and I get the error below... Any ideas?

2013-09-22 18:36:46,066 22176 ERROR test openerp.report.render.rml2pdf.utils: Failed to evaluate expression [[ (picking.address_id and picking.address_id.partner_id and picking.address_id.partner_id.title.name) or '' ]] with context {'get_product_desc': <bound method picking.get_product_desc of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'setLang': <bound method picking.setLang of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'display_address': <bound method picking.display_address of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'uid': 1, 'objects': [browse_record(stock.picking.out, 1)], 'format': <bound method picking.format of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'strip_name': <bound method picking._strip_name of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, u'default_type': u'out', u'active_ids': [1], 'digits_fmt': <bound method picking.digits_fmt of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'user': browse_record(res.users, 1), 'get_digits': <bound method picking.get_digits of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, u'search_disable_custom_filters': True, 'logo': False, 'picking': browse_record(stock.picking.out, 1), 'data': {'report_type': u'pdf'}, 'name_space': {'style': '{openoffice.org/2000/style}', 'number': '{openoffice.org/2000/datastyle}', 'form': '{openoffice.org/2000/form}', 'office': '{openoffice.org/2000/office}', 'script': '{openoffice.org/2000/script}', 'ooow': '{openoffice.org/2004/writer}', 'text': '{openoffice.org/2000/text}', 'chart': '{openoffice.org/2000/chart}', 'dom': '{www.w3.org/2001/xml-events}', 'draw': '{openoffice.org/2000/drawing}', 'dc': '{purl.org/dc/elements/1.1/}', 'xlink': '{www.w3.org/1999/xlink}', 'meta': '{openoffice.org/2000/meta}', 'svg': '{www.w3.org/2000/svg}', 'table': '{openoffice.org/2000/table}', 'dr3d': '{openoffice.org/2000/dr3d}', 'oooc': '{openoffice.org/2004/calc}', 'ooo': '{openoffice.org/2004/office}', 'math': '{www.w3.org/1998/Math/MathML}', 'fo': '{www.w3.org/1999/XSL/Format}'}, u'active_id': 1, 'lang': u'en_US', 'bin_raw': True, 'tz': False, 'setCompany': <bound method picking.setCompany of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, u'active_model': u'stock.picking.out', 'removeParentNode': <bound method picking.removeParentNode of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'setHtmlImage': <bound method picking.set_html_image of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'formatLang': <bound method picking.formatLang of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'repeatIn': <bound method picking.repeatIn of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'setTag': <bound method picking.setTag of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'time': <module 'time' (built-in)>, u'contact_display': u'partner_address', 'translate': <bound method picking._translate of <openerp.addons.stock.report.picking.picking object at 0x7f1b700e19d0>>, 'company': browse_record(res.company, 1)} while rendering report, ignored.

Still looking for solution. Can someone share what combination of openERP + Open Office(Apache or Libre?) works for you? Thank you!

Pavel Pavlov
on 9/23/13, 9:29 AM
0
Pavel Pavlov
On 9/23/13, 12:27 PM

Hello,

Seem like there is problem somewhere in my setup of openERP 8(latest trunc of today) + Libre Office 3 .

I've tried today syncing the openERP v7 branches, installed Open Office 3.4(on win this time) and I was able to receive <-> send the report multiple times without destroying it...

Regards, Pavel

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

0 follower(s)

Stats

Asked: 9/22/13, 5:00 PM
Seen: 2288 times
Last updated: 3/16/15, 8:10 AM