I'm trying to display all sales invoice lines for particular invoices. I need to filter the Order Date from the Sales Invoice Header and also display that on the report. I have linked the two tables (see image), but when the report runs, I only get the first Sales Invoice Line on the Invoice, not the rest of the lines. Thoughts?
Sales Invoice Header and Sales Invoice Lines Link