SQL Server - Dynamic SSRS Report Name when exporting to PDF or Excel.

Asked By jason barry on 22-Aug-13 12:58 AM
Assuming a SSRS report is being used by a user, and they select a parameter (called @UNIT) and refresh the report based on the paramter and would like to export the report to EXCEL. Is there a way to export the report with the result of the parameter (@UNIT in this case) to which they have selected. For example the @UNIT value is 'PSU Sydney'. Can the report be exported as PSU Sydney.xls........ I understand Data driven subscriptions can handle this, however on a manual export is where I would like to know if this is possible? thankyou