ssrs report columns not aligning with headers

2020-02-15 12:33发布

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条回答
劳资没心,怎么记你
2楼-- · 2020-02-15 13:04

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

查看更多
一纸荒年 Trace。
3楼-- · 2020-02-15 13:04

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.

查看更多
登录 后发表回答