Share via

How to embed excel file when export SSRS report to word document

priya Gohil 0 Reputation points
2023-03-23T16:20:45.1633333+00:00

Hello, I am exporting SSRS report to word format. In my word format there is a requirement to to show some embed excel file. Those excel files are SSRS report exported to excel. How can I embed the excel file in the word format? Any help is appreciated. Please see attached image. I want to show in the word document as shown in the image.

User's image

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.
2,911 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2023-03-24T01:45:59.7066667+00:00

    Hi @priya Gohil

    You can use the "go to URL" function to provide a full shared link to the excel file to navigate to the excel file. You can see this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-hyperlink-to-a-url-report-builder-and-ssrs?view=sql-server-ver16.

    When you export a report as a Word document, the Word document retains hyperlinks and drillthrough links.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments
  2. Olaf Helper 43,901 Reputation points
    2023-03-27T08:51:11.5233333+00:00

    How can I embed the excel file in the word format?

    That's not possible with SSRS build-in features.

    0 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.