RS Report Not Showing Column Headers on Every Page

SQL Server Administration
12

You created row groupings and they look correct to me.

I attached a few screenshots. I wanted to attach a sample RDL file but it's not allowed.

These screenshots illustrate how I don't have to create any "fake" groups.

image
image1475×447 24.7 KB

Here you can see the report repeating headers on each page:

image
image920×414 24.9 KB

This screenshot is from the RDL file. I only show the important pieces that control the repeating headers:

image
image1025×799 23.1 KB

If you can't get your existing report to work I would start from the beginning:

  1. Add a tablix to the report and get your data setup
  2. Only display one or two columns of data on the tablix
  3. Turn on the Advanced options for groups
  4. Set the RepeatOnNewPage to True
  5. Preview the report and see if it repeats on new pages

There are some frustrating aspects to SSRS as with all technology. Once you get those things working it's not so bad but getting there is painful.

1 Like