September 12, 2021

Repeat the header on all pages of the table in SQL Server Report builder

It was around mid morning when the client requested me to build a tabular report with details and calculations that would display around 40,000 rows. Relaxed and knowing how a low code task that was, I hastily created the report and reported back. Every value and details was okay save for the repeating header on each page. The client made a genuine request of having the table header repeated on every page of the report.