Need to Create a report based on Invoice products with Invoice amount and Payment received. When a view is Created each lines contains invoice amount and payment received against the invoice lines. 

Can anyone provide a query with Invoice lines in one column and the total Invoice amount and the total invoice amount collected.

for example 10 products in an invoice with products in 10 rows and invoice amount and payment received in first row only.