locked
Freeze Tablix Column Headers while Scolling RRS feed

  • Question

  • User963319391 posted

    Hi

    I am generating rdlc report. My doubt is i want to freeze the Table header (like excel freeze)in the rdlc report while scolling. I has tried the method below but its not working:

    FixedColumnHeaders = True;
    Keep Header Visible While Scrolling = True


    Tuesday, August 27, 2013 5:56 AM

Answers

  • User-734925760 posted

    Hi,

    According to your description, please refer to update the property below:

    AsyncRendering="True"

    SizeToReportContent="False"

     Fixed Data="True"

    There is a similar thread about set FixedHeader, please refer to the link below:

    http://social.msdn.microsoft.com/Forums/en-US/33fc08b3-1947-44a6-a5bd-53ccd7ddacd5/vs-2010-report-freeze-columns

    http://stackoverflow.com/questions/4781592/freezing-column-headers-while-scrolling-in-ssrs

    Hope it’s useful for you.

    Best Regards,

    Michelle Ge

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 28, 2013 11:01 AM
  • User-1051986203 posted

    go through the below link:

    http://technet.microsoft.com/en-us/library/ee240753.aspx

    http://remicaron.wordpress.com/2010/01/05/how-to-get-ssrs-to-repeat-the-row-headers-tablix-2008/

     Basically few below steps are involves to freeze tablix column header while scrolling:

    You need to open Advanced Mode in the Groupings pane: click the arrow to the right of the Column Groups and select Advanced Mode. You'll see Static Groups appear in the Row Groups area. Clicking on a Static group highlights the corresponding textbox in the tablix. For the column headers that you want to repeat, select the Static group that highlights the leftmost column header. This is generally the first Static group listed. In the Properties window, set the RepeatOnNewPage property to TrueMake sure that the KeepWithGroup property is set to After & FixedData is set to True . The KeepWithGroup property specifies which group to which the static member needs to stick. If set to After then the static member sticks with the group af-ter, or below, it acting as a group header. If set to Before, then the static member sticks with the group before, or above it, acting as a group footer. If set to None, Reporting Services decides where to put the static member. Now when you view the report, the column headers repeat on each page of the tablix and scrolls.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 2, 2013 8:53 AM

All replies