Problem: A custom made report (with Studio) is printed (or the pdf is generated) with all the fields translated into the language of the user in Odoo, instead of the language of the contact for whom the report is intended.

Use case: A newsletter is sent to the contacts of a company. Of course, this should be in the language of the contact that will receive the letter. The goal is that fields like for example the title of a contact (mister, miss) are translated into the language of the receiving person.

Cause: In reports such as an invoice (translated into the contact’s language by default), a context is added in the XML code to indicate this. This XML code is missing if you create a report in Studio from scratch.

Solution: Add this piece of code in the XML code:

<t t-set="doc" t-value="doc.with_context(lang=doc.partner_id.lang)" />

What it means in human language: we’re adding a context to this report, which sets the language of the report to the language of the partner that’s present in the document from which we’re generating the report.

How to get the language?

If you are generating a report from the contacts app (as in the example above), you just need the value of the language field -> doc.lang

If you are generating a report from an app like accounting, there is an extra step to go through the contact itself -> doc.partner_id.lang

Step by step guide

1) Go to the report you created in Studio

2) Go to Report -> XML (the developer mode has to be activated)

3) In the dropdown, select the one that starts by studio_customization. and ends with _document.

4) Copy the entire thing: “studio_customization.studio_report_docume_c8a3a442-df5c-4463-96cd-c90eb64439cb_document”

5) Go (in debug mode) to the views in the technical settings

6) Search for the line you copied in step 4

7) Open the one where the ‘key’ is the same as the line you copied

8) Add the piece of code