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
Бухоблік
Склад
PoS
Проект
MRP

All apps

All Posts Люди Значки

Мітки (View all)

odoo accounting v14 pos v15

Про цей форум

Допомога

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

reports Binary v18

2 Відповіді

187 Переглядів

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Реєстрація

Related Posts	Відповіді	Переглядів
Where is the PDF Partner Ledger QWeb Report and View in Odoo Online? v18	1 груд. 25	3352
Change Sign & Pay Button on Quotation E-mails v18	3 лист. 25	595
Problem including JS asset in v18 v18	3 лист. 25	8986
Code for page number in Body of Pdf report reports	2 жовт. 25	3407
How to increase the width of a column on odoo quotation PDF? reports	1 жовт. 25	1253

Це запитання позначене

Enjoying the discussion? Don't just read, join in!