Skip to Content
This question has been flagged
reportinggroup_byqweb-reportodoo10odoo10.0
4 Respostes
8899 Vistes
Avatar
Sasmita

Hello Community,Please help. I hava a problem when I create pdf report in qweb.....

I try this in myCustomize Modul and Report

<t t-set="i" t-value="1" />

<t t-foreach="request.env['x_surat_usul'].search([])" t-as="obj">

    <tr t-foreach="obj.x_pengajuan_materiil" t-as="a">

        <td class="text-center"><span t-esc="i"/><t t-set="i" t-value="i+1"/> </td>

        <td><span t-field="a.x_komponen" /></td>

        <td><span t-field="a.x_jum_ang_approve" /></td>

    </tr>

</t>

Then show

No   Category      Amount

1       Fasilitas             3

2       Fasilitas             2

3       Rumdin              2


And I want showing

No   Category      Amount

1       Fasilitas             5

2       Rumdin              2


Thanks ...


Avatar
Descartar
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

Hi Sasmita,

As Sehrish said, you should create a parser of the report and then call a method in parser from xml.

Ex:

def get_rec(self, rec):
    vals = {}
    for cat in rec.x_pengajuan_materiil:
        if cat.x_komponen.name in vals:
            vals[cat.x_komponen.name] += cat.x_jum_ang_approve
        else:
            vals.update({cat.x_komponen.name: cat.x_jum_ang_approve})
    return vals

XML:

<!-- Save method value in variable -->
<t t-set="recs" t-value="get_rec(obj)"/>
<tr t-foreach="recs.keys()" t-as="a">
<!-- Print category name -->
    <span t-esc="a"/>
<!-- Print category amount -->
    <span t-esc="recs[a]" />
</tr>
Avatar
Descartar
Avatar
Sehrish
Best Answer

I will suggest you to handle data in report parser (using python logic instead of XML), check this how to create custom report using parser: http://learnopenerp.blogspot.com/2016/09/how-to-create-custom-reports-in-odoo.html

Avatar
Descartar
Avatar
Sasmita
Autor Best Answer

Thanks for the answer. But I get error in your query sudhir  :)

do you have any solution ??

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Attach Report While Printing
reporting attachments odoo10 odoo10.0
Avatar
Avatar
1
de jul. 18
12048
Ttwo reports with same template but different orientation not working
qweb-report odoo10.0
Avatar
Avatar
Avatar
Avatar
4
de nov. 20
7191
How to create a report with custom data and use that data in QWEB report?
qweb-report odoo10
Avatar
Avatar
4
de març 20
18493
Header and footer missing in qweb report Solved
qweb-report odoo10.0
Avatar
Avatar
Avatar
Avatar
3
d’ag. 19
9679
Get id from model in qweb report
qweb-report odoo10
Avatar
Avatar
3
de maig 18
8013