Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
If you have a table which spans multiple pages in SSRS, you'll find that the column headers appear on only the first page when you run the report.
These column headers will appear on only the first page of a report.
This can make it tricky to read the table after the first page.
To make the column headers repeat on each page, first enable Advanced Mode in the Grouping Pane.
Use the drop arrow in the top-right corner of the Grouping Pane to enable Advanced Mode.
Select the (Static) item at the top of the Row Groups panel and change its RepeatOnNewPage property to True.
The (Static) item at the top of the Row Groups panel represents the header row of the table.
If you also want the column headers to remain visible as you scroll down the page, set the FixedData property to True.
You can now see your column headers on each page when you run the report:
These column headers will appear at the top of each of the 78 pages in the report.
You can learn more about this topic on the following Wise Owl courses:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.