Thank you Bruce for your reply.
I've tested your response to #1 and found it to be a bit quirky. I picked row 5 to freeze as it was the row with my headers on it; YTD, Last YTD, etc. It immediately moved row 5 to row 1. And yes that line does print on each page. However my report title now prints below this line on page 1. The only way it works correctly is to include row 1 to row 5 even if I don't want rows 1 - 4 repeated.
So I'm making the assumption it will work but only if you start at row 1. Is this correct?
Thanks for your responses to #2 & #3. I will work around it.