I built an SSRS report using SSRS Report Builder 3.0 2008 R2.  When I preview the report in report builder, everything works as it should.  The drilldowns work, the column header scrolls with the data (as in, the header is always visible on the top of the screen as I scroll down) ... it all works.

When I access the report through the UI on the report server, the column headings do not scroll; they disappear off the top.  I have tried adjusting the page size and the interactive page size and that didn't help.  I do not have access to change the settings of the report server page; I work for a large company and they would be resistant to making sweeping changes to settings on the report server.

I have a table view (not a matrix), so they way I got the headings to scroll in the report builder was to adjust the static group headings so that: FixedData = True, KeepTogether = True, KeepWithGroup = After, RepeatOnNewPage = True, Hidden = False

Since it works in Report Builder, why doesn't it work on the report server?  Is there anything I can add to it to get the scroll to work in both locations?

Hi CHJoski,

on the tablix properties did you check below?

I'm not using a matrix.  When I have those boxes checked, I get errors that I have conflicting settings.

I'm using the instructions given in this MSDN article  https://msdn.microsoft.com/en-us/library/dd220509.aspx .  Trust me, I've tried the "easy fixes" and it's not something that obvious.

The headers scroll with the report when I am in the Report Builder, but not when deployed to the Report Server and viewed there.  If they are working in Report Builder, I have my settings set right somewhere.

Could this be an issue with the settings of the report server?

Hi CHJoski,

What I wanted to convey is to uncheck the above settings in the Tablix properties

I was able to achieve your requirement and it working fine in both report server and report viewer

Below is the image of settings I used to achieve

Hi, 

According to your description, when opening a report on report server, the column header doesnt scroll, right? 

In our local environment, we have tested this scenario and the report behavior has no difference on report server and Report Builder. In your scenario, since the report can run fine in Report Builder, the report has no issue. The deployed report may has the uncorrect FixedData value. For your issue ,we suggest you download the deployed report and open it with Notepad. Please check if the FixedData element value is true. If not, you need to change it to true. For more detail information, please refer to this blog: Fixed Headers With SSRS

If you have any other question, please feel free to ask. 

Regards,