How to display multi page PDF file ( stored in the sql server database as binay data ) in SSRS 2008 report?

avlexperts
avlexperts used Ask the Experts™
on
I have table called Document, it has documentId, interger and DocumentImage, varbinary(max) columns in sql server 2005 database.
documentImage column has PDF file content as binary data.

how do i display this pdf file on SSRS 2008 r2 report?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
MIS Liason
Most Valuable Expert 2012
Commented:
First you will need a system to translate the BLOB data back into a pdf.
See here:
http://support.microsoft.com/kb/258038
The kicker here is if SSRS can "Display" PDF's directly...
You may have to save this to a temp file and display that in your report.

If SSRS can't display the PDF you may need a control that can...

In MS Access for example, you can use the webbrowser control to display the PDF *On a form* (not a report)
Not sure if SSRS can display a PDF in a web browser control...?
Harish VargheseProject Leader
Commented:
Couple of options to show PDF from report:

1. http://www.sqlservercentral.com/Forums/Topic970422-150-1.aspx#bm1168354 
This link explains how you can include a link that will open the PDF file in separate window.

2. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/541a46fc-4288-49f2-96a2-0ac45c18f5bd/
See Bipin.P's post describing the link option.

3. http://www.codeproject.com/Articles/34551/Reporting-Services-2008-Embedding-a-PDF-Document 
This link explains how you can convert PDF into image and show on the report.

-Harish
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial