I need to be able to run a report to see totals for invoices in Canada without seeing each line of the invoices themselves.
Click Reports under Standard sales and seller's use tax reports
Click Export report
Choose Documents level
Choose your criteria for report
You should now see a report that has only the header level information for each invoice.