Hi many thanks for that reply - it's gone completely over my head though I'm afraid 🙁 I've never used functions.
When I was developing this app I pretty much knew I'd hit a brick wall when it came to this report 🙁 I thought that having a months table may help with SSRS creating a matrix.
Is there not just a way I can select every month from my months table and for each month a list of clients with invoices in that month being summed?
Thanks,
Stephen.