SSRS Header (Fixed) is displaced when scrolling left to right

Question

Hi,

I'm using Report Builder 3.0 for my SSRS.  have a tablix report where I would like to have my row and column header fixed. I fixed the column header using the RowGroups>AdvancedMode>Static> Fixed Data True, KeepGroup After, RepeatHeader True then FixedRowHeaders True for my row header. The headers are fixed ihen scrolling down in Report Builder although the row header overlaps when scrolling to the right.

In the web report, I have no problem scrolling down but when I scroll down then right, the rows in my header are displaced.

Also I have 2 horizontal and vertical scroll bars which is a pain since I have to scroll down first before I can scroll right. 

I would really appreciate any help.

Thanks a lot,

Cielle

Answer 1

Hi Cielle,

Based on my understanding, you design a report on Report Builder 3.0 with fixed row header. When you scroll right, the fixed header works fine in Report Builder 3, however, the fixed header displaced on Report Manager.

In Reporting Service, if we choose “Header should remain visible while scrolling” option, generally, the column header will be displaced and visible as we scroll right. So please check if you select this item in Tablix Properties. If so, please unselect this option then check if issue persists. Besides, as we tested in our environment, fixed row header works fine both on Report Builder 3.0 and Report Manager. Please refer to the screenshots below:

So in your scenario, I would like to know the detail settings for row headers and your report design. If possible, please provide some screenshots about scroll right results both on Report Builder 3.0 and Report Server.

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

Best regards,
Qiuyun Yu

Answer 2

Hi Quinyun,

Thanks for your reply.

As stated above, I fixed the headers using the Advanced Mode and the FixedData Tablix Properties.

In the report builder, they overlap:

https://social.msdn.microsoft.com/Forums/getfile/565383

In the web, scrolling down is good until I scroll right where the rows are displaced

https://social.msdn.microsoft.com/Forums/getfile/565384

Unfortunately, I can't attach the images in the body as it says that this forum needs to verify my account first, which I don't know how. Hope the links work.

Thanks,

Cielle

Answer 3

Hi Cielle,

We can’t view the image through the link you provide. As you mentioned you couldn't upload images, you can verify your account to fix this issue. Please refer to this thread: Verify Your Account 23.

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

Best regards,
Qiuyun Yu

Answer 4

Hi Quiyun,

Here's how it looks like in the Report builder:

Here's when I scroll down then right in the Web Report:

Thanks,

Cielle

Answer 5

Hi Cielle,

Could you change the IE Browser version to the supported version to check if issue persists? Please refer to steps below:

1. Launch the IE, and press F12.
2. Click Emulation icon on the left of the bottom and in the User agent string dropdown list select a supported version.

3. If the supported version works fine, try to reset IE to that version. Please also check the result in IE Compatibility View mode.

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

Best regards,
Qiuyun Yu

Answer 6

Thanks Quiyun! It is working now