I am trying to create a report which has a tiered grouping of line by line invoice details for a multiple clients grouped by the client then by an invoice number, but I have been unable to achieve this with much grace.

We are looking to have the following set up

Client 1 summary details - Account manager,  YTD sales, Current month spend etc.

     Client 1 invoice 1 Summary details - Totals, Paid date etc

          Client 1 Invoice 1 line details

     Client 1 invoice 2 Summary details - Totals, Paid date etc

          Client 1 Invoice 2 line details

Client 2 summary details - Account manager,  YTD sales, Current month spend etc.

     Client 2 invoice 1 Summary details - Totals, Paid date etc

          Client 2 Invoice 1 line details

     Client 1 invoice 2 Summary details - Totals, Paid date etc

          Client 1 Invoice 2 line details

I can achieve the Client summary line with line details of all invoices beneath it but can not nicely add in the invoice summary's for 1 or more invoice.  some attempts have shown just 1 invoice listed with parts for all invoices beneath it whiclst other attempts have given me the invoice summary line before each item line.  I am convinced that this is something to do with the sections in the report I have created but can not work out what should be where.

Can anyone shed any light on how this can be achieved?

Ultimately this will be an excel output (or Excel integrated report) so I just need column titles for each grouping of data.

Thanks in advance.

Leon