locked
how to Freeze Row header in matrix report of SSRS-2012 ?? RRS feed

  • Question

  • Hi All,

    I have a matrix report where i have a row and column group.My report is of around 100 pages.

    I need to freeze the header and i want it to show in every page.

    Do any 1 have idea how to fix it ???

    Thanks in Advance.

    Regards

    MsbiLearning

    Friday, August 30, 2013 2:42 PM

Answers

  • Hi Satya,

    It is working for simple report.But mine is matrix report.

    Do u have any other solution.

    Thanks in advance.

    Regards

    Msbilearning.

    Hi ,

    I tried with matrix and it is working , right-click on matrix - > Tablix properties - > Column Headers ->

    check these 2 options :

    Repeat header columns on each page

    Keep header visible while scrolling


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    • Marked as answer by msbilearning Monday, September 2, 2013 6:52 AM
    Sunday, September 1, 2013 4:27 AM

All replies

  • Hi ,

    Try this link http://social.technet.microsoft.com/wiki/contents/articles/19398.ssrs-how-to-repeat-headers-on-each-page.aspx


    sathya --------- Mark as answered if my post solved your problem and Vote as helpful if my post was useful.

    Friday, August 30, 2013 7:23 PM
  • Hi Satya,

    It is working for simple report.But mine is matrix report.

    Do u have any other solution.

    Thanks in advance.

    Regards

    Msbilearning.

    Saturday, August 31, 2013 7:52 PM
  • Hi Satya,

    It is working for simple report.But mine is matrix report.

    Do u have any other solution.

    Thanks in advance.

    Regards

    Msbilearning.

    Hi ,

    I tried with matrix and it is working , right-click on matrix - > Tablix properties - > Column Headers ->

    check these 2 options :

    Repeat header columns on each page

    Keep header visible while scrolling


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    • Marked as answer by msbilearning Monday, September 2, 2013 6:52 AM
    Sunday, September 1, 2013 4:27 AM
  • Thanks a lot sathya..It worked....:)

    Monday, September 2, 2013 6:52 AM