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:

https://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.

Comments

• Anonymous
  October 09, 2008
  PingBack from http://www.easycoded.com/repeatwith-not-working-with-physical-paginations-like-print-image-and-pdf/

• Anonymous
  November 11, 2009
  my report in SSRS contains a table with a table footer. when i export the report to CSV, the table footer data gets prepended to each detail row in the csv. how can one avoid this. Also for TIFF format export, only the part that fits in 1 page is seen, the rest of the report is not rendered in tiff.

• Anonymous
  November 12, 2009
  The comment has been removed