Is it possible to get attachments stored in a database blob to then render in an SSRS report?

Hi Experts is it possible to get attachments stored in a database blob to then appear in an SSRS report?

If yes is it better to use word or pdf.

Many thanks,
C
bruskhickoryAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Data DudeCommented:
Just a thought ... why?

If you want the reports to generated based on available data, then keep them as SSRS reports.
If you want the reports numbers to never change, the store as a .pdf on the file system.
bruskhickoryAuthor Commented:
Hi Jim,

Sorry I was not very clear with my question. I have a database which is populated from another application. One of the details captured are attachments of word and pdf stored in a blob.
I need to create a report which will return a bunch of other details plus return the Word/Pdf document users of the application have added. I don't want to have a link but add the actual document. Is that possible?
Many thanks,
PortletPaulEE Topic AdvisorCommented:
I haven't done this ever, so I have no personal experience but here is a reference for embedding PDFs into SSRS output. Note it requires a custom CLR function. This article is dated 2009.

http://www.codeproject.com/Articles/34551/Reporting-Services-2008-Embedding-a-PDF-Document

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bruskhickoryAuthor Commented:
I have not tried the solution but I will update this page if I find anything later that the link provided from 2008 ssrs version.
Many thanks,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.