Hello, I have an xml file to generate a report a my.model: My report Report my.model qweb-pdf my_app.my_template my_app.my_template <field name="binding_model_id" ref="model_

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Custom module: Can I generate and store a PDF report in a binary field - Odoo 18

reports Binary v18

2 Vastaukset

185 Näkymät

Boris Giordanengo

Hello,

I have an xml file to generate a report a my.model:

<odoo>
    <template id="my_template">
        <t t-call="web.html_container">
            <t t-foreach="docs" t-as="o">
               My report
            </t>
        </t>
    </template>

    <report id="my_report" model="ir.actions.report">
        <field name="name">Report</field>
        <field name="model">my.model</field>
        <field name="report_type">qweb-pdf</field>
        <field name="report_name">my_app.my_template</field>
        <field name="report_file">my_app.my_template</field>
        <field name="binding_model_id" ref="model_my_model"/>
        <field name="binding_type">report</field>
    </report>
</odoo>

This code is working file.
I also know how to generate the pdf report via a button, but I don't know how to generate this pdf report as a binary field of my.model (report_id = fields.Binary('pdf report')).

Thanks,

Boris

Cybrosys Techno Solutions Pvt.Ltd

Hi,

You can generate a QWeb PDF report programmatically and store it in a Binary field on your model.The correct approach is to call the report action from Python, render the PDF in memory, and then write the resulting bytes to a binary field. You do not need to trigger a download or rely on a button action that returns a report.

First, define the binary field on your model:

from odoo import models, fields

class MyModel(models.Model):

_name = 'my.model'

report_pdf = fields.Binary(string="PDF Report", attachment=True)

report_pdf_name = fields.Char(string="PDF Filename")

Then, generate and store the PDF using ir.actions.report. In Odoo 18, the supported API is _render_qweb_pdf:

from odoo import models, api

import base64

class MyModel(models.Model):

_name = 'my.model'

def action_generate_pdf(self):

report = self.env.ref('my_app.my_report')

pdf_content, _ = report._render_qweb_pdf(self.id)

self.write({

'report_pdf': base64.b64encode(pdf_content),

'report_pdf_name': f'Report_{self.id}.pdf',

})

This method renders the same PDF as your XML report definition, but instead of returning it to the browser, it stores it directly in the database.

Setting attachment=True on the binary field ensures the file is stored efficiently in ir.attachment and can be downloaded later. You can then expose this field in a form view to allow users to download the stored PDF.

Hope it helps

Jainesh Shah(Aktiv Software)

Hello Boris Giordanengo ,

Yes, you can generate a PDF report and store it in a Binary field in Odoo 18 using a custom module. You can achieve this by following the steps below

1) Add New Fields to Your Model

class MyModel(models.Model):

_name = 'my.model'

report_id = fields.Binary(

string='PDF Report',

attachment=True

)

report_filename = fields.Char(string='Report Filename')

2) Add Button and Fields to Your Form View

<button name="action_generate_pdf_report"

type="object"

string="Generate PDF"

class="btn-primary"/>

3) Create the Button Action:

Define a Python method that generates the PDF report and stores it in the Binary field

4) Generate and Store the PDF:

When you click the Generate PDF button, the report will be generated and automatically stored in the Binary field as an attachment

This solution allows you to generate a PDF report and store it directly in a Binary field using standard Odoo functionality.

If you have any questions, feel free to reach out.

Hope this helps!

Thanks and Regards,

Email: odoo@aktivsoftware.com

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Where is the PDF Partner Ledger QWeb Report and View in Odoo Online? v18	1 jouluk. 25	3352
Change Sign & Pay Button on Quotation E-mails v18	3 marrask. 25	595
Problem including JS asset in v18 v18	3 marrask. 25	8986
Code for page number in Body of Pdf report reports	2 lokak. 25	3407
How to increase the width of a column on odoo quotation PDF? reports	1 lokak. 25	1253

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!