RepeatWith not working with Physical Paginations like Print, Image and PDF
PROBLEM:
When we set the RepeatWith property of a TEXTBOX to the table / data region that holds the data, the textbox is not shown in other pages after rendering the report in PDF / Print Preview / Image.
WHY?
The behavior you are seeing is by design. The RepeatWith functionality is not supported in "physical pagination" renderers: Print, Image, and PDF.
SOURCE:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=349132
WORKAROUND: (Different scenarios discussed)
1) Any controls that need to repeat before the table should be moved into the table header. Each row in the table header should be set to RepeatOnNewPage=True and The RepeatWith property should not be set.
2) Any controls that need to repeat in the table footer or after the table should be moved into a new detail row in the table. The RepeatWith property should not be set. Any controls currently in the table footer that are not set to RepeatWith should be left where they are. RepeatOnNewPage should be False for the rows in the table footer.
3) All the controls that were moved into the new detail row in the table should have the Visibility, Hidden=True set.
4) Create new controls in the Page Footer which reference the hidden controls in the Table. e.g. textbox24.Value = ReportItems!textbox4.Value, where textbox24 is in the Page Footer and textbox4 is a hidden control in the detail section.
