I apologise, maybe I wasn't clear in my question.

What you have told me I understand.

What I want to know is can I put out the column header once only in row 1 the all the rest of the rows are data.
AS for import to excel. Not column header repeated on each page break

From what I see with experimenting that the report writer is not designed to output as requested.

Is this correct?