Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
3 Antworten
4311 Ansichten

hello all,

i have date range from 01/06/2020 to 05/06/2020, in that i have 4 records each records have some calculation like, qty.

i want following result:

Date: 01/06/2020

            record 1: 10 qty

            record 2: 20 qty

            total : 30 qty

Date: 03/06/2020

            record 1: 5 qty

            record 2: 3 qty

            total : 8 qty

grand total : 38 qty


How can i got this type of result?

Avatar
Verwerfen

Hi ,

for this you want to get this in a list view as a filter or what ?

Can you explain More your request please

Beste Antwort

https://speedysense.com/create-custom-report-odoo-12/

Sample Qweb report template based on your requirement:-

<template id="template_id" name="Template">     
<t t-call="portal.portal_table">
<thead>
<tr>
<th>Date</th>
<th>Record No#</th>
<th>Quantity</th>
</tr>
</thead>
<tbody>
<tr t-foreach="record" t-as="r">
<td>
<t t-esc="r.fieldname1"/>
</td>
<td>
<t t-esc="r.fieldname2"/>
</td>
<td>
<t t-esc="r.fieldname3"/>
</td>
</tr>
</tbody>
<div class="row" name="total">
<tr class="border-black">
<td colspan="3">
<strong>Total qty:</strong>
<t t-esc="sum([r.fieldname3 for r in record])"/>
</td>
</tr>
</div>
</t>
</template>


Avatar
Verwerfen
Autor Beste Antwort

Hello imad chaikhi,

i want this in qweb pdf report.

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
1
Dez. 17
3567
1
Juli 16
5640
3
Feb. 25
3503
0
Mai 24
46
1
Apr. 24
3330