locked
Column headers not staying visible throughout. RRS feed

  • Question

  • I added the Tablix properties on this report that allow me to keep the column headers and it continues to not show the column headers.
    Monday, February 5, 2018 7:56 PM

All replies

  • Check the Repeat header rows on each page in the Row headers section.

    Ousama EL HOR

    [If a post helps to resolve your issue, please click the "Mark as Answer"  of that post or click Answered "Vote as helpful"  button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]


     [User Page]     [MSDN Page]     [Blog]     [Linkedin]

    Monday, February 5, 2018 8:00 PM
  • I did.  It doesn't show.
    Monday, February 5, 2018 8:03 PM
  • SOunds like you've column and row groups present

    In which case you need to do like this

    https://www.sqlchick.com/entries/2011/8/20/repeating-column-headers-on-every-page-in-ssrs-doesnt-work-o.html


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Monday, February 5, 2018 8:03 PM
  • Monday, February 5, 2018 8:07 PM
  • Monday, February 5, 2018 8:08 PM
  • Hi soldierfc,

     If you want to display column header on each page, you could configure tablix like below(I set page break between each instance in [cate] in Row Groups)

     Then you will get the result like below

    You could refer to Display Row and Column Headers on Multiple Pages for details.

    Best Regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Tuesday, February 6, 2018 6:19 AM
  • Hi soldierfc,

    May I know how is your issue going currently? If your issue is solved please mark the appropriate answer as Mark as answer.  This will help other members to find a solution if they face the same issue. If you still have any questions, please feel free to ask.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, February 9, 2018 9:07 AM