Apply Classifications to SSRS Report headers/footers

CC 96 Reputation points

Using SSRS on prem.

We have many reports and are looking for a way to apply header/footer classifications or notices.

Is there any way to do this via a script, or are we in a situation:

  1. Create header and footer as sub-reports
  2. Embed sub-reports into all reports that need header and footer classifications/notices

We can't do blanket all reports in the Reports folder due to some .rdl files are helper sub-reports, so the classifications would just be redundant to what's in the parent report.

Thank you!

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,727 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points

    Hi @CC ,
    Do you want to apply the header and footer of the report to other reports? I am sorry that I am not good at using scripts.
    You could refer to: Update all SSRS reports to apply consistent header / footer on demand.
    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.