Report Master and Details

Hello all,
I want to make a query report for the sales invoices that will be as follows:

Row: master data from the invoice like ID, customer name, …etc
under this row I want to list all invoice items with its quantity.

So any advice or there anyway to do this ?!

Bellow an attachment for the report view I need:

Have a look at this report:
erpnext/manufacturing/report/bom_operations_time/bom_operations_time.py

1 Like

I’ll do, thanks in advance

you can achieve with simple sql query

can you pls share a sample query…

Can You Please Share a sample of how to achieve it ?!