SQL Server Report Builder

September 12, 2021
Repeat the header on all pages of the table in SQL Server Report builder

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.