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

Mindphin Technologies pvt ltd, 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]

Relaterade inlägg	Svar	Vyer
Print order list sale report	0 jan. 16	5107
Using ireports, is there any reason why my settings for padding and bordering show up in digital prints but not physical? report saleorder	0 mars 15	5039
Sale Order report printing in A5 but PDF Quote also affected – how to fix? pdf report saleorder	2 maj 26	661
sale profit report module sale report profit	0 aug. 16	4943
Hide lines with zero quantity from sale order report report lines saleorder pdfreport	1 apr. 24	3296

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!