How to show header in excel while scrolling

How to show header in excel while scrolling how to#

Click on the Preview tab on your report and deploy the report to Reporting Services.

Change Tablix Member properties for the Static element as shown.

A properties box will open on the right side of the page for this Static element.Click on the top Static cell which represents the first column header of the report. A вЂњStaticвЂќ property element will show above your Row Groups as shown below.In the Design tab of your report, click on drop down arrow on the far right side of the Grouping Section and select Advanced Mode.When properties dialog box opens, un-check the вЂњKeep header visible while scrollingвЂќ checkboxes for both Row Headers and Column Headers.Right click on the upper left corner of your Tablix to open the Tablix Properties.In Visual Studio, make sure you are on the Design tab of your report.

How to show header in excel while scrolling how to#

The following steps will demonstrate how to make it work. You have even set the properties of your Tablix to вЂњKeep Headers Visible While ScrollingвЂќ, but it still doesnвЂ™t work! Trying to keep the column headings visible while you scroll down the page of your SSRS report can be a frustrating endeavor. So letвЂ™s say you have successfully created an SSRS report using Visual Studio, and everything looks wonderfulвЂ¦except the headers on your columns disappear when you scroll down the page. When scrolling through the pages of a SQL Server Reporting Services (SSRS) report, it is very useful to be able to see the column headers throughout the report.