How to repeat Tablix header on every page of SSRS report

-
Problem

After paginating the SSRS report on the previous article, I encountered another problem displaying Tablix header on multiple pages.

Solution
  1. Ensure View | Properties is checked
  2. Click on the following triangle icon to select Advanced Mode
  3. Click on the first static on the Row Groups and set the Tablix Member | Other | KeepWithGroup:After and RepeatOnNewPage:True

Explanation

The selected (static) row to repeat on the new page was actually the header of the table (Tablix). You can visually identify the highlighted-part of Tablix as you click on the (static) row on the Row Groups.

If you want the header to display on browser when scrolling down, ensure Tablix Member | Other | FixedData: True

Comments

Post a Comment

Popular posts from this blog

How to search Active Directory group members using Windows 10 built-in tools

-
Image
Problem I need to check Active Directory group members but have limited access to install any software on a remote Windows machine running on Windows Virtual Desktop infrastucture. Solution To search for the group name, open  File Explorer | Network | Network | Search Active Directory and if you cannot see the members on the result column, you can run cmd.exe and use the following command to see the members of the Active Directory group: net group THE_AD_GROUP_NAME /domain
Read more

How to check and reload PAC (Proxy Auto Configuration) file on Windows

-
Problem I need to check PAC file content being used by Chrome and Internet Explorer on my Windows PC however company administrator has locked down the proxy settings on browser and Windows 10. Solution Run the following command via CMD.EXE on Windows reg query "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings" /f AutoConfigUrl To force Chrome to reload PAC file, use the following URL and click Clear bad proxies followed by Re-apply settings chrome://net-internals/proxyservice.config#proxy For Internet Explorer, you may need to reboot Windows for the PAC file to reload via Active-Directory Group-Policy.
Read more