ssrs report columns not aligning with headers

0
votes

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

2
reporting-servicesssrs-2008ssrs-2012ssrs-tablix

2 Answers

1
votes

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

1
votes

By default, everything scrolls together. You may have inadvertently enabled one of the Keep header visible while scrolling options in the table properties. The other property that could affect this is if you went into advanced mode in your groups and turned on the KeepWithGroup or KeepTogether properties. If you set those all back to false, the whole report will scroll together.