Thanks but I am still not quite there. I have now got the record repeated in the query and hence in the report. Do you know how to get the record headers repeated too? When I just copy them on the report I get:
Header
Header
Record 1
Record 1
What I want is:
Header
Record 1
Header
Record...