Geek Answers Handbook

Freeze column headers in browser while scrolling

I am trying to freeze all column headings in a report while scrolling down. I read a lot of articles on how to switch to advanced mode, select the title and set FixedData to True, KeepWithGroup - After, RepeatOnNewPage - True. This works when previewing the report, but it does not work in the browser. I tried using IE 11, Chrome, and other browsers, but none of them fix column headers while scrolling.

I spent hours trying to get this to work, and read articles such as: Lock column heading while scrolling . and Freezing column headers when scrolling in SSRS , but none of them do this in the browser.

I tried to create a simple table report from the report wizard and follow these instructions, but it still does not work. This is very important for working with SSRS. I am using SSRS 2012. Any help would be greatly appreciated.

+4
source share
5 answers

It seems that the corrected headers simply do not work in the ASP.NET Report Viewer control. I have a simple aspx page with a ReportViewer control that checks it in IE 11. Corrected headers work in Preview and Report Manager, but not in ASP.NET Report Viewer. So I decided to just show my reports using the built-in Report Viewer. Fixed column headers.

+1
source

, HTML - CSS, position:fixed;?

+1

. , . , .

, , SSRS 2012, , . , , ReportingServices.js Chrome.

el.style.overflow = "visible" "auto" IE. - if, IE, , IE- (window.addEventListener).

if (el  && window.addEventListener)
    el.style.overflow = "visible";

, , ReportingServices.js,

function pageLoad() {
   el = document.getElementById("ctl32_ctl09"),

   //Fix Chrome invisible report
   if (el  && window.addEventListener)
      el.style.overflow = "visible";
}
if (window.addEventListener) {
   window.addEventListener('load', pageLoad, false);
} else {
   window.attachEvent('onload', pageLoad);
}

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\ Reporting Services\ReportManager\js\ReportingServices.js

+1

IE 9. IE 11 . IE 11 ( ) , IE 11 .

Instructions for using compatibility mode. 1) Right-click at the top of the window, and then select the “menu bar”, 2) click the tools in the menu 3) Click “Compatibility View” to add the current web URL to the list of pages displayed in the compatibility view, this list can be controlled simply by clicking "Compatibility View Settings"

Hope this helps ... I could not find it anywhere else.

0
source

More articles:


All Articles