Thanks for your help, I'm using SSRS, so I just took your idea and applied it to calculated fields in my dataset. I have 1 calculated field for each...
I'm grouping the page by project manager for them to see their outstanding invoices, then grouping by project so they can see total amount owed for each project, but then...