Got it figured out.
Added a group and just used the footer. Works great!
I've created a report that takes every line from the invoice and displays them based on parameters of date range.
My problem is misc charges. I can easily export the misc charges separately and manually add each line to each invoices, but this is very labor intense.
We would like to run calculations on the quantity and invoice price, but not add additional column for misc. charges.