Search code examples
reporting-servicesssrs-2008ssrs-2012ssrs-tablix

ssrs report columns not aligning with headers


My ssrs report headers are not aligning with the columns when I scroll. Below is the report, as it misaligned when I scroll right, I've tried placing it in a rectangle but that didn't work too.

enter image description here

I'm trying to freeze the first two columns and want to have the rest scroll through as I scroll right.

enter image description here


Solution

  • If you want the header visible while scrolling, you need to go to tablix properties > General and check the option Keep header visible while scrolling. Then go to column/row groups in the advanced mode, chose your static row and set the Fixed Data mode to True, Repeat on new page to True and Keep with group to After.

    Here is prbably the best reference: Here