A very tricky question, indeed.
I fear there is no solution that can be achieved with the current versions of the Report Template Editor. Maybe this can be achieved by writing a custom code assembly, but you need to know VB programming to do it.
Best regards, - betrich
I was afraid that was the case..... I will take a look at the custom assembly route (I'm ok with some custom assembly stuff) though I don't think it's a good solution in our situation.
Sometimes the right thing to do is just say no.... I'll let them know.
Very much appreciate the validation!