Export to Excel--customizing the save option

Hi,
Am creating reports using Sql Reporting services. Suppose am creating a
report for all the users and the file name is "User Report" and am passing
the "username" by parametervalue. while exporting it to excel, a dialogue box
appears which gives an option of 'open','save','cancel' with "user
Report.xls". but what if i have to save it specific to the paramvalue i.e-- "
<username> UserReport.xls"'I dont think you can do that just from the report Manager.
You will have to write your own application to display the
reports and the provide a export to excel option and then
render the report in excel format(using the Web Services
Render method) and save the excel file from code with the
desired filename.
>--Original Message--
>Hi,
>Am creating reports using Sql Reporting services. Suppose
am creating a
>report for all the users and the file name is "User
Report" and am passing
>the "username" by parametervalue. while exporting it to
excel, a dialogue box
>appears which gives an option of 'open','save','cancel'
with "user
>Report.xls". but what if i have to save it specific to
the paramvalue i.e-- "
><username> UserReport.xls"'
>
>.
>