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.
We have recently developed a new method to handle this and are looking at updating all reports to use this new method.
Please keep in mind however, the reason we have had to work around this is due to the limitations Microsoft have placed on SSRS and Word. We can only account for so much on our side and as such we offer export formats like word, but can't support them fully as SSRS doesn't export into Word very well.
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 ...
Hi Brian,
We have recently developed a new method to handle this and are looking at updating all reports to use this new method.
Please keep in mind however, the reason we have had to work around this is due to the limitations Microsoft have placed on SSRS and Word. We can only account for so much on our side and as such we offer export formats like word, but can't support them fully as SSRS doesn't export into Word very well.
Regards
Joe
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 ...