How to display PDF file from database in SSRS Report

Devin 1 Reputation point
2022-04-29T05:22:31.407+00:00

Hi Team,

I had an issue displaying the PDF file from the database in SSRS Report?

There is no option for MIME types for PDF. Can you please advise if there is any way to achieve it?

Thanks
Devin

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,807 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2022-04-29T05:40:35.447+00:00

    if there is any way to achieve it?

    It's simply not possible, you can not embed PDF or any other kind of documents inside a report.
    SSRS is for reporting/displaying data; that's it's main duty.
    If you want to show documents, then head out for other solutions like Sharepoint.

    1 person found this answer helpful.
  2. Isabellaz-1451 3,616 Reputation points
    2022-04-29T06:40:51.657+00:00

    Hi @Devin

    I recommend you use a power bi desktop，you can get data from the PDF directly，then do some transform and exports the data to a .csv file.

    197595-image.png

    197613-image.png

    You can download power bi desktop from here：https://powerbi.microsoft.com/en-us/desktop/

    Best Regards，
    Isabella

    0 comments