Launch SSRS Reports with external PDF files into a single PDF file as output

TamilselvanP 1 Reputation point
2022-01-18T10:08:04.093+00:00

Hi,
We are using SSRS 2019. we have requirement from our customer to merge the external PDF files(scanned copy of manual log books) while launching SSRS report as single PDF file.

Please let me know the best way to implement this.

Thanks,
P. Tamilselvan

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2022-01-18T11:10:38.363+00:00

    That's not possible. You can not embedd a PDF or other document in a SSRS report, you can only link it if it's stored on a share or within SSRS.

    0 comments No comments

  2. Joyzhao-MSFT 15,631 Reputation points
    2022-01-19T07:59:17.707+00:00

    Hi @TamilselvanP ,
    I'm afraid you can't embed pdf files in SSRS. But you could try to embed the PDF in the report as Images:

    • To Embed the PDF inside SSRS report you need to first embed PDF in database as the image data and show them on SSRS report
    • Use the .net language either C# or VB to convert this data into the image.
    • Use the image control to show these images, which are your PDF document embedded in database.

    For more details please refer to: Embedding a PDF Document.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.