How to join multiple tables and display a report

[Viral]

Hello Experts,

I have a parent child invoice tables as below:

Parent (Invoices)

Invoice ID

Invoice Date

Customer ID

Child(InvoiceItems)

Invoice ID

Item No

Material ID

Quantity

Price

Is there a way to generate a slice or any other means so to display below information:

• Get total quantities of each material which were invoiced between a date range.
• Get total quantities of each material which were invoiced per customer.

Just like SQL, I am looking for a way to join two tables and carve out information from Child tables based on filter criteria from parent table. Also to sum child fields based on above selection.

[1minManager]

How are looking to do this?  As a table in a report, a view or just to use the filtered table view?

[Viral]

may be with a view would be fine.