question

CC-4427 avatar image
0 Votes"
CC-4427 asked Joyzhao-MSFT commented

Apply Classifications to SSRS Report headers/footers

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @CC-4427 ,
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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi...thank you for the reply.
We'd want to keep the existing report headers & footers since those list parameters used in the report along with existing title, and footers contain information for when users print the report.

'Best route' would be actually appending something to both the header and footer...or even appending something to the top/bottom of the body area.

0 Votes 0 ·

Sorry for my lack of experience using scripts.
If you are desperate to resolve this issue, you can consider using telephone support (this may require payment of some fees).
https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
https://support.microsoft.com/en-us/supportforbusiness/productselection

0 Votes 0 ·