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

Question

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.

Answer 1

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

Answer 2

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

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