locked
header repition in ssrs RRS feed

  • Question

  • hi,

    how to repeat header row in ssrs table except in first page?

    thanks

    Tuesday, July 5, 2011 6:18 AM

Answers

  • Hi sudeep Puvvadi,

    Base on my research, we can control header row to repeat on every page or just the first page. If there is a need to display header row on all other pages except the first page, I tried to control visibility of the header row by expression =Iif(Globals!PageNumber=1,true,false),but the global variable PageNumber can be used only in the page header and page footer.

    So, it comes to my mind to move column headers to page header area, instead of having header row in table in the body area by the steps below:

    1. Add page header to report.
    2. Drag as many textbox as you need to page header area, double click textbox, and type column header name in textbox.
    3. In Page Header properties, set PrintOnFirstPage to False.

    Any questions, feel free to ask.

    Thanks, 
    Lola Wang


    Please remember to mark the replies as answers if they help.
    Thursday, July 7, 2011 7:41 AM

All replies

  • Which version of SSRS are you using?

    Please refer: http://technet.microsoft.com/en-us/library/cc627566(SQL.100).aspx [How to: Display Row and Column Headers on Multiple Pages (Reporting Services)]

    Additionally, you can refer this forum thread: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/ee29da49-5c8c-47f3-a905-c730dcbe9780

    Hope this helps..

     


    Chaitanya( Twitter | Blogs )

    Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
    This posting is provided "AS IS" with no warranties, and confers no rights.

    The next CTP for SQL Server Code Name "Denali" is coming soon. Sign up now to be notified of the next CTP release.
    Tuesday, July 5, 2011 6:29 AM
  • ssrs 2008
    Tuesday, July 5, 2011 6:31 AM
  • Please follow the above suggested link,  http://technet.microsoft.com/en-us/library/cc627566(SQL.100).aspx [How to: Display Row and Column Headers on Multiple Pages (Reporting Services)], and let me know if you still unable to get the header repeating...

     

    Thanks..

     


    Chaitanya( Twitter | Blogs )

    Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
    This posting is provided "AS IS" with no warranties, and confers no rights.

    The next CTP for SQL Server Code Name "Denali" is coming soon. Sign up now to be notified of the next CTP release.
    Tuesday, July 5, 2011 6:46 AM
  • Hi sudeep Puvvadi,

    Base on my research, we can control header row to repeat on every page or just the first page. If there is a need to display header row on all other pages except the first page, I tried to control visibility of the header row by expression =Iif(Globals!PageNumber=1,true,false),but the global variable PageNumber can be used only in the page header and page footer.

    So, it comes to my mind to move column headers to page header area, instead of having header row in table in the body area by the steps below:

    1. Add page header to report.
    2. Drag as many textbox as you need to page header area, double click textbox, and type column header name in textbox.
    3. In Page Header properties, set PrintOnFirstPage to False.

    Any questions, feel free to ask.

    Thanks, 
    Lola Wang


    Please remember to mark the replies as answers if they help.
    Thursday, July 7, 2011 7:41 AM