Repeating headers issue

Scott Case 1 Reputation point
2022-03-30T17:27:27.807+00:00

We have a "master" report that first calls 5 subreports, then executes its own logic. There are static rows (ProviderName & ProgramAreaCodeDescription) which we are attempting to use as a repeat-on-new-page header for subsequent row group (ProgramAreaCodeDescription1). We have set the properties according to the documentation to no avail. The header correctly repeats for a change in the ProgramAreaCodeDescription, but not for new pages.

188497-ssrsrepeatheaderexample1.png188485-ssrsrepeatheaderproperties1.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2022-04-01T07:58:32.487+00:00

    Hi @Scott Case

    Generally speaking, we set a row to repeat on new page, first open the advanced mode,then select this row, and then set the properties
    188995-image.png

    then we can get this row repeated on new page .
    Here is an example screenshot:
    189081-image.png

    If your issue still not fixed,please show us the fully master report and subreport ? and how is the preview look like ?

    Best Regards,
    Isabella

    0 comments No comments

  2. Scott Case 1 Reputation point
    2022-04-01T12:50:58.947+00:00

    Thank you Isabella, for looking into this. I have done all of that to no avail. What I am beginning to wonder is: Does a Details group have to exist for the headers to repeat? For this particular report, all of the groups are static.

    0 comments No comments