Apply Classifications to SSRS Report headers/footers

CC 96 Reputation points
2021-05-14T20:49:10.553+00:00

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

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,631 Reputation points
    2021-05-17T09:39:07.517+00:00

    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,
    Joy


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.