how to get a summarized row in odoo for the SQL Query

Question

hi, this is an SQL that generates the report by Sales Order in detail.  I have made some changes to the query according to my need but now I want a summarized row that displays the sum of quantity, sub-total and total amount of all rows at the bottom.
Please help on how to achieve this.
elif data.get('report_type') == 'report_by_order_detail':
query = '''
SELECT  ru.id [1] ,
so_line.product_id, res_users.partner_id, so.payment_status
'''
self._cr.execute(query)
report_by_order_details = self._cr

Surbhi Parmar · Answer

elif data.get('report_type') == 'report_by_order_detail':

query = '''
SELECT
ru.id [1] ,
so_line.product_id,
res_users.partner_id,
so.payment_status,
so_line.quantity,
so_line.sub_total,
so_line.total_amount
FROM
your_table_name ru
JOIN
your_other_tables so ON ru.id [2] = so.ru_id
JOIN
your_other_tables so_line ON so.id [3] = so_line.so_id
JOIN
your_other_tables res_users ON so.user_id = res_users.id [4]
'''

# Append GROUP BY and SUM functions for summarized row
query += '''
GROUP BY
ru.id [5]

Gerelateerde posts	Antwoorden	Weergaven
Print order list sale report	0 jan. 16	4442
sale profit report module sale report profit	0 aug. 16	4162
Using ireports, is there any reason why my settings for padding and bordering show up in digital prints but not physical? report saleorder ireports	0 mrt. 15	4446
Hide lines with zero quantity from sale order report report lines saleorder pdfreport	1 apr. 24	2361
Move element to next page of pdf. xml sale report template	4 okt. 23	6644

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!