T-SQL code or CLR convert BLOB PDF to image

Question

0.00/5 (No votes)

See more:

I have a table that stored binary pdf files.
So the table has a binary data type but the actual file in the binary record is a PDF document.
What I need to do is convert that binary PDF File to an image file so that I can display the image\PDF in a SSRS Report.
I would like to do this through a stored procedure but I have a feeling I am going to have to create a CLR but I don't know where to begin

What I have tried:

I tried creating the SSRS Report to view the binary file but it won't work. SSRS does not have a PDF viewer so I have to convert that PDF to image.

Posted 12-Aug-20 3:07am

John Robert Connolly

Updated 12-Aug-20 4:26am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2020-08-12T04:26:00

Solution 1

There might be more ways but for one of it, here you go, details well explained in one of our own CP article: Reporting Services 2008 – Embedding a PDF Document[^]

Look at it, see if it works out of box for you (seems should be), or else seems good enough a start to build on it and try out.

Posted 12-Aug-20 4:26am

Sandeep Mewara

Updated 12-Aug-20 4:28am

v2