Displaying a PDF from Database in SSRS

Question

Good Morning, 

I am using SQL Server 2005 and SSRS 2005, and I am trying to display a PDF (image datatype, application/pdf filetype) from a SQL Database.  There is no MIME option for PDF, so it seems my options are limited.  Is there a way to display the PDF, or maybe convert the binary data at the database level?

Like most requests posted in forums, this is an urgent matter and any help would be greatly appreciated.

Answer 1

Hello,

In Reporting Services, we can display image which stored in database by using Image control. Currently, it is not support display PDF document in report.

To work around this issue, we convert the PDF object to image and return a dataset of images. The following blog shows the detail steps about this workaround. Please take as reference.
http://www.codeproject.com/Articles/34551/Reporting-Services-2008-Embedding-a-PDF-Document

Regards,
Fanny Liu

---

Fanny Liu

TechNet Community Support

Answer 2

I have a same problem..... Did you find a solution? (beside the link that is provided by Fanny