![]() Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful. How do you freeze the tablix header row in an Excel export file in SSRS 2008 Split panes to lock rows or columns in separate worksheet areas. In the properties grid, set RepeatOnNewPage to trueġ)Freeze the header of all columns : To do select static member of table header row from row groups and set FixedData to trueĢ) Freeze the initial 2 columns : To do select static member of columns in column group and set fixedData to true. Freeze panes to lock the first row or column in Excel 2016 for Mac. Select the corresponding (Static) item in the row group hierarchyģ. In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane)Ģ. Now the header row will be remain fixed in the report.ġ. In the General tab under Column Headers section you can see "Keep header visible while scrolling" checkbox, check it.ģ. ![]() Select the tabix and click on Tablix properties.Ģ. ![]() Possibly relevant information:-All computers are using Excel 2010.-The file in question is stored on the company network, not locally. Thanks for your post, You can achive your requiremets by using the below logic. Now my coworker, on any of these same computers, can open this same file but for him, the freeze pane is at the bottom of row 13, not row 17.
0 Comments
Leave a Reply. |