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.

With all the confidence, I checked the report properties and found an amazing property, repeat header on every page. I check marked the boolean to true and tested a sample data to verify if the solution had worked. To my surprise it didn’t work.

The bitter solution that worked for me at that time was to repeat all headers in the report header section of the page, by using text boxes and aligning them manually for about 30 more minutes.

For future reports when the client requested, I simply replied, the builder doesn’t currently support the function.