question

Devin-4788 avatar image
0 Votes"
Devin-4788 asked IsabellaZhangMSFT-7746 commented

How to display PDF file from database in SSRS Report

Hi Team,

I had an issue displaying the PDF file from the database in SSRS Report?

There is no option for MIME types for PDF. Can you please advise if there is any way to achieve it?

Thanks
Devin

sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @TathiahDevin-4788

We have not get a reply from you. Did any answers could help you?
If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered Devin-4788 commented

if there is any way to achieve it?

It's simply not possible, you can not embed PDF or any other kind of documents inside a report.
SSRS is for reporting/displaying data; that's it's main duty.
If you want to show documents, then head out for other solutions like Sharepoint.
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your time; I've been looking around, but it's hard to find the relevant solution.

0 Votes 0 ·
IsabellaZhangMSFT-7746 avatar image
0 Votes"
IsabellaZhangMSFT-7746 answered IsabellaZhangMSFT-7746 edited

Hi @Devin-4788

I recommend you use a power bi desktop,you can get data from the PDF directly,then do some transform and exports the data to a .csv file.

197595-image.png

197613-image.png

You can download power bi desktop from here:https://powerbi.microsoft.com/en-us/desktop/

Best Regards,
Isabella


image.png (13.9 KiB)
image.png (18.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.