SSRS API download .pdf

Angus Beare 1 Reputation point
2020-09-29T20:31:31.667+00:00

With the API I can do this: http://10.0.15.78/reports/api/v2.0/Reports(01234567-89ab-cdef-0123-456789abcdef)/Content/$value Which sends back the report (.rdl) file. However, I am hoping to make a simple client app with a tree of report folders and allow the user to download a report as a .pdf. Is this possible with the API? thanks

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,496 Reputation points
    2020-09-30T02:46:28.17+00:00

    Hi @Angus Beare ,

    So far I know currently, there is no method available in RestAPI.

    https://app.swaggerhub.com/apis/microsoft-rs/SSRS/2.0#/Reports/GetReportAllowedActions

    We can optionally specify the format in which to render a report by using the rs:Format URL parameter. The HTML4.0 and HTM5 formats (rendering extension) will render in the browser and for other formats, the browser will prompt to save the report output to a local file.

    For example, to get a PDF copy of a report directly from a native mode report server:

    https://myrshost/ReportServer?/myreport&rs:Format=PDF  
    

    For reference:https://learn.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-server-ver15

    We could also download SSRS reports as PDF using C#.

    https://www.craftedforeveryone.com/download-sql-server-reporting-service-ssrs-report-as-pdf-using-c-sharp/

    Regards,

    Zoe


    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.