Thanks, those are much easier to read.

I have tested against SSRS, I will be using the coalesce query alongside the usual where clauses.

Thanks again.