I have a database that's based on the Invoice Starter Solution. I'm wanting to create a report like the following, have tried to do this with sub-summary parts, but can not get my head around the correct way of doing it. Hope someone can put me in the right direction.
|InvoiceNumber||InvoiceDate||CustomerName||Total Invoice Price||VAT||Cat1||Cat2||Cat3|
This would show each invoice on a line, with the invoice line items broken down by their category. For example, 2 products above are in 'Cat1' and 1 product is in Cat2. So this is totalled per invoice, and then each invoice split up the totals by the categories, which are set in the 'Product' table in the database.