If Word is to remain an option when exporting the Data Collection Sheet, it needs to be formatted correctly.
When exporting a Custom report using Word it is not formatting correctly. First Pupil name on document is duplicated throughout all the pages and appears twice in the Header.
I would suggest that this is not an 'Idea' and it doesn't just affect Word export; I consider that the Data Sheet report is faulty and this should be dealt with by iSAMS as a ticket.
In order to get the student name into the header they have used a fudge of a hidden name field on the page, the contents of which is picked up by the header. But because one student can go over more than one page, there need to be two copies of the fudge to deal with the situation when first field that the header is trying to read is not available on the page. The result of this double fudge is that some formats (screen, Word, Excel) show the student's name twice, but worse, as you note, the Word renderer deals with the report's page header as a whole-document header with only the first pupil's name in.
I don't know why they didn't use the SSRS Group PageName attribute, which gets rid of the need for hidden fields and also the double name textboxes in the header, but I am not sure whether that would help make the Word renderer use 'sections' with different headers for different pupils ...
I would suggest that this is not an 'Idea' and it doesn't just affect Word export; I consider that the Data Sheet report is faulty and this should be dealt with by iSAMS as a ticket.
In order to get the student name into the header they have used a fudge of a hidden name field on the page, the contents of which is picked up by the header. But because one student can go over more than one page, there need to be two copies of the fudge to deal with the situation when first field that the header is trying to read is not available on the page. The result of this double fudge is that some formats (screen, Word, Excel) show the student's name twice, but worse, as you note, the Word renderer deals with the report's page header as a whole-document header with only the first pupil's name in.
I don't know why they didn't use the SSRS Group PageName attribute, which gets rid of the need for hidden fields and also the double name textboxes in the header, but I am not sure whether that would help make the Word renderer use 'sections' with different headers for different pupils ...