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 install OpenVPN server on Raspberry Pi

-
Image
Download Raspberry Pi Imager . Install Raspberry Pi OS Lite on 16GB microSD card. Remember to click the Setting icon to enter your Wifi SSID and password as well as enabling SSH and default username: pi and password: raspberry   Insert the microSD card onto the Raspberry Pi  and power it up via USB power supply. Get the IP address of the Raspberry Pi (via HDMI or wifi-router web-console) then configure port forwarding on the router WAN interface for  TCP 443  to the IP address of the Raspberry Pi. Download PuTTY and run it to connect to Raspbian via SSH ( Host Name: IP Address of the Raspberry Pi then click Open  and if prompted by Putty alert, click Yes ) then  login as: pi and password: raspberry . To change default password and timezone use the following command: sudo raspi-config Run  curl -L https://install.pivpn.io | bash  and follow the wizard to install OpenVPN server. When prompted: Protocol , select TCP  443 then Ok C...
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

Failed to update site content type - Column Order due to aborted thread

-
Image
I encountered error when updating Column Ordering of a site content type on a root web with 6000 sub-webs via web browser: http://SharePoint2010.intranet.abc.com/ _layouts/ChangeFieldOrder.aspx ?ctype=0x01007654335D3BA08148A3410EAA36350F99 I then checked the ULS log on the Web Front End server and found the following error: System.Threading.ThreadAbortException: Thread was being aborted.   at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 )   at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout)   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()   at System.Data.SqlClient.TdsParserStateObject.ReadByte()   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand c...
Read more