locked
Render BLOB as PDF in Image Report Item or in another way, directly in SSRS report, no custom assemblies allowed, no separate websites allowed RRS feed

  • Question

  • What I'm trying to accomplish is, directly within my SSRS report, the ability to render a PDF from a BLOB field from the database.  So I'd like to have a simple table in my report with a field that has a link in it; when clicked the link would open the PDF in a new window. 

    I do not have access to the SSRS server to add custom assemblies (this is not an option).  Similarly, I do not have access to our web servers to create a website to render the PDF from Blob, and then link to there from my SSRS report, so we cannot go that route either.  No separate websites and no custom assemblies allowed; any solution here must be directly within my SSRS 2005 report.  

    I could use an Image Report Item and render images within my report directly from the database BLOB; however my images are PDF, and PDF is not a supported MIMEType for the Image Report Item.  I want to avoid the extra effort, risk and db growth of adding a new BLOB field and converting all the PDF BLOBs to JPGs or other image type.  Is there a way to force SSRS to accept PDF as a MIMEType for the Image Report Item?

    I have been trying to add in some VB code to the report to allow the PDF to be rendered.  Something like:

           Response.ContentType = "application/pdf" 
           Response.BinaryWrite(DirectCast(MyPDF, Byte()))

    But I am not able to add References to System.Web.UI to the SSRS report.  Can we force SSRS to accept System.Web.UI, or is there another built-in assembly and other rendering code that I can use here?

    Hope this makes sense - and thanks for your assistance!
    Wednesday, September 16, 2009 5:10 PM

Answers

  • The simple answer is no. Not with the constraints that you have defined. You have explicitly ruled out both suggestions that I would have made.
    Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)
    Wednesday, September 16, 2009 5:24 PM

All replies

  • The simple answer is no. Not with the constraints that you have defined. You have explicitly ruled out both suggestions that I would have made.
    Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)
    Wednesday, September 16, 2009 5:24 PM
  • Hi Speedcat,

    I know im replying to a really old post and clutching at straws but i am trying to do exactly what you were trying to do back in 2009 .

    Did you ever have any success at getting the PDF blobs to show in Reporting Services?

    Thanks

    Dave

    Monday, April 11, 2011 8:57 PM