CODEWITHSUNDEEP
sqlsql-serverexcelreporting-servicessend
Azuraith
Azuraith

Reputation: 1050

Is it possible to pass information from ssrs to excel?

I am trying to pass information from an ssrs report to an excel spreadsheet. What I want to accomplish is clicking a link in an ssrs report that opens up an excel spreadsheet, but also populates a cell in that excel spreadsheet with a value from the ssrs report where it was opened from.

I have achieved opening the excel spreadsheet file from the ssrs report by adding an action to a textbox and using the Go to URL Action

=Fields!True_Path.Value & "\" & Fields!DOCUMENT_ID.Value

However, i want to pass the value of the textbox itself to the excel spread sheet. Is this possible? If so how could one accomplish this task? Any methods / suggestions are welcome!

Upvotes: 0

Views: 803

Answers (1)

kubasnack
kubasnack

Reputation: 91

Yes, you can create a macro enabled workbook and pass the value in a parameter. In your SSRS report, you will use a formula or variable. The format would look like this.

Server\ShareFolder\TheWorkbook.xlsm" /e/myParam

There is a great response to how to pass parameters to excel in the Office Microsoft Forums. You can find it here

https://social.technet.microsoft.com/Forums/office/en-US/bb9fa94f-a1d4-45cd-9279-b12e7a7e69c0/passing-a-parameter-to-an-excel-file-when-opening-it?forum=excel

Upvotes: 1

Related Questions