How to set title of pdf in report builder

Anonymous
2022-03-10T13:44:14.387+00:00

We have an issue with PDF files generated by SSRS for reports created in Report Builder. The files have weird looking names/titles when opened with the built-in PDF viewer in Chrome etc. Some searching returned a thread saying that Chrome displays the title element of the PDF file. Looking at https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-a-pdf-file-report-builder-and-ssrs?view=sql-server-ver15#Metadata the title should be set based on the name attribute in the report. The problem is, according to the RDL specification a name attribute is not allowed on the Report element (also Report Builder fails to open the report if I try to add it). So how do I set the report name so that it propagates correctly to the title property in the PDF file and displays correctly in Chrome etc.?

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

3 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,591 Reputation points
    2022-03-11T03:37:21.95+00:00

    Hi @Anonymous
    If I understand correctly, you want to add custom properties/metadata(e.g. Status, Catagories, Subject) to the exported PDF document.
    If so, we need to implement a customized Rendering Extension to accomplist the traget. We can start implementing a Rendering Extension from here: http://msdn.microsoft.com/en-us/library/ms153624.aspx
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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. Anonymous
    2022-03-11T07:26:51.79+00:00

    I'm not sure it is custom properties. According to the documentation linked, the report name should already be part of the built-in metadata. When we generate PDF documents using our RDL file they are named using a hash value. Google shows this when opening the document in-browser:
    182120-image.png
    And when trying to save the document from the in-browser viewer:
    182181-image.png
    So I just want to know how/where to set the mentioned attribute of the report in the RDL file

    0 comments No comments

  3. MargieLC 1 Reputation point
    2024-05-02T22:28:17.48+00:00

    Hi, Have you managed to find answer to your question. I am having the same dilemma as well and cannot find anything in the net. Thanks.

    0 comments No comments

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.