• 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.