1. Click on the down arrow on the side of Column headers at the bottom of the Report area/section.
2. Turn on the Advanced mode if not already on, by making sure that there is a check mark against it.
3. Once this mode is turned on, you will see static columns under Row Groups as well as Column Groups.
4. Select the very first Static section under Row Groups and this will open up the Properties pane on the right hand side for this static section
5. In the properties pane, set the following 2 properties :
a) KeepWithGroup = After
b) RepeatOnNewPage = True
I believe this is all we have to do to make the column headers repeat on each page. Since these settings are not a very obvious part of the report design process, I tend to forget them each time and thought it might be worthwhile to add them to my blog so I can refer to them next time I need to create such a report.
This is excellent information. I've linked to this so that I can use this next time, because I always forget how to do this. Thanks, Ritu.
ReplyDeleteWes