locked
RESOLVED: reportviewer: "Show column headers on each page" not working in web page RRS feed

  • Question

  • User-1514795968 posted

    ASP.NET VS2010 SQLSVR 2008

    I have a report (rdlc) file with a table and I specify in the tablix properties:  Repeat header columns on each page. 

    But column headers only appear on page 1.

    Reports is hosted in a reportviewer on an ASPX page. 

    I tried the keep header visible while scrolling and that also does not work.  Since this is rendered in HTML, I could see how the scrolling may not be an option, but the " Repeat header columns on each page" option should work.

    Any ideas?

    EDIT:

    I found this,

    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/49527307-c0a3-4734-a46e-f87cf84e3189/

    which looked very promising, but did not work.  when I set the "<RepeatOnNewPage>true</RepeatOnNewPage>" I then get a compile error saying they must all be false.  Kind of defeats the purpose.

    Error 1 The tablix 'Tablix1' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false. C:\...\App_Code\Report.rdlc 1 

     EDIT:

    Resolved:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/54e605d4-07b4-40d9-925d-563f81a0828b

    Need to set "<RepeatOnNewPage>true</RepeatOnNewPage>" on Row Group, not Column.  First link also said to set it on the Row, I guess I read Column, since that makes the most sence.  Well, thinking about it, it's the Row I want too pin, not the column, so yes, Row Group.

     

     

     

    Thursday, January 13, 2011 11:44 AM

Answers

  • User1471008070 posted

    Hi,

    From your information, I notice that you have solved the issue, below is your solution:

    Resolved:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/54e605d4-07b4-40d9-925d-563f81a0828b

    Need to set "<RepeatOnNewPage>true</RepeatOnNewPage>" on Row Group, not Column.  First link also said to set it on the Row, I guess I read Column, since that makes the most sence.  Well, thinking about it, it's the Row I want too pin, not the column, so yes, Row Group.

    Great thanks for your sharing the information.

    Regards,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 17, 2011 4:56 AM