Just set up my first reporting services solution in SQL 2005. Going gangbusters, but ran into one problem. I need to save the report to an Excel spreadsheet and pdf, but need to attach the report parameters to the file name. For example, the name would be something like 'Monthly Issues', but when executed from a subscription or other method, need to be automatically saved as 'Monthly Issues 12345 0909', where 12345 is the account number parameter/result and 0909 is the month/year parameter/result.
Can this be accomplished by either a script to execute the report (preferred, but don't know how to script a report execution with parameters) or via a subscription in RS?