none
Repeat header if Detail row continues on next page(SSRS 2008R2)

    Question

  • Hi All,

    I have ssrs 2008 R2 and in my report I have grouped by owner , title, and the detail row has Document summary .

    The document Summary field in detail row is varchar(max) field and contains long descriptive text spanning multiple pages for some rows. On the second and subsequent pages when the document summary for the row continues to the next page. i dont see my group headers repeating.

    What i want is owner and title field repeat for the same row if that row continues onto the next page and also the header text repeat on every page, even if the row splits to the next page.so that we know the document summary refers to which owner and title.

    i have tried going into the advanced Mode and tried setting all the properties for the related static fields like RepeatOnNewPage = True , KeepWithGroup = After, FixedData = True and also the KeepTogether = True. But none of them have helped.

    I dont want to page break after each group since that will have many pages.

    Would appreciate any solution or workaround for the problem.

    Thanks

    Sud


    sud

    Tuesday, November 12, 2013 5:44 PM

All replies

  • Did you Try setting repeat Header on Each Page property for the container?

    Tuesday, November 12, 2013 6:26 PM
  • Yes I have tried row headers and column headers and also tried deleting and doing the table again. But it has not helped. The problem is it is the same row continuing on the next page and so the owner and title columns and the headers dont repeat.

    Thanks

    sud


    sud

    Tuesday, November 12, 2013 6:47 PM
  • Hi Sud,

    From the screenshot, you should export the report in Word format. I have tested the issue in my test environment (SQL Server 2008 R2 Reporting Services) and can replicate it.

    The issue occurs because there are Word limitations when exporting the report to Word. Word does not repeat header rows on page two and greater, although you set the RepeatOnNewPage property of the static header row in a tablix (table, matrix, or list) to True. In this case, you can define explicit page breaks in the report to force header rows to appear on new pages. However, Word applies its own pagination to the rendered report exported to Word, results might vary and the header row might not repeat predictably. Here, the static header row is the row that contains the column headings.

    For the detailed information, please refer to the link: Exporting to Microsoft Word (Report Builder 3.0 and SSRS)

    Regards,
    Heidi Duan

    Heidi Duan
    TechNet Community Support

    Wednesday, November 13, 2013 6:58 AM
  • Hi Heidi,

    Thank you for trying to help.

    I am trying to export to pdf and still have the same problem. The problem with the explicit page breaks is the row(varchar(max)) has long descriptive text. it would be difficult to page break with the long row ,unless i split the row into multiple lines of text.

    Thanks

    sud


    sud

    Wednesday, November 13, 2013 5:01 PM