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:
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 True. Make 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.
Member
29 Points
88 Posts
Freeze Tablix Column Headers while Scolling
Aug 27, 2013 05:56 AM|Jane1987|LINK
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:
Member
70 Points
30 Posts
Re: Freeze Tablix Column Headers while Scolling
Aug 27, 2013 06:41 AM|Subramanyam.N|LINK
Try this
http://msdn.microsoft.com/en-us/library/bb934257.aspx
Member
29 Points
88 Posts
Re: Freeze Tablix Column Headers while Scolling
Aug 27, 2013 09:59 PM|Jane1987|LINK
Hi,
I has follow exactly the same method as shown in the link above, but the header does not freeze when i scoll my table up and down.
Anyone can help me?
All-Star
18232 Points
2199 Posts
Re: Freeze Tablix Column Headers while Scolling
Aug 28, 2013 11:01 AM|Michelle Ge - MSFT|LINK
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
Participant
1220 Points
336 Posts
Re: Freeze Tablix Column Headers while Scolling
Sep 02, 2013 08:53 AM|jeeveshfuloria08|LINK
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 True. Make 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.