Odoo Help


How to show many2many field in openoffice report?

on 11/19/14, 4:40 AM 1,141 views

Model : sale.order

Field : terms_condition --- many2many field(terms.condition)

Model : terms.condition

Field : list_name --- char field

I want to display many2many fields in my openoffice report.

But when i give the below code it not working:

[[ repeatIn(objects, 'o') ]]
[[ repeatIn(o.terms_condition,'line') ]]
[[ line.list_name ]]


Please help me.




you can try like this.

   <para style="terp_default_Centre_9">[[ ', '.join([ tc.list_name or '' for tc in o.terms_condition ]) ]]</para>

Just put this paragraph into block table where you want to print all your terms and condition.

Hi, How can apply the code in sxw file. I dont know the code. I tried many ways but shows error. Can we generate report only with rml file?

on 11/21/14, 11:57 PM

Hi, Just replace your last two lines with the line : [[ ', '.join([ tc.list_name or '' for tc in o.terms_condition ]) ]] thats it.

Emipro Technologies Pvt. Ltd.
on 11/22/14, 12:19 AM

I tried,but its printing the [[ ', '.join([ tc.list_name or '' for tc in o.terms_condition ]) ]] same. In my report.

on 11/22/14, 12:30 AM

one more thing is : In my module,it contains a report folder. In report folder - init file, py file and the rml file. But in my interface it doesnt shows the report. How can i connect the report with my database?

on 11/22/14, 12:34 AM

Thanks. its now working in my sxw file. Report name is not displaying in the quotation print list

on 11/22/14, 12:43 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

1 follower(s)


Asked: 11/19/14, 4:40 AM
Seen: 1141 times
Last updated: 3/16/15, 8:10 AM