Save report to dynamic file name

Last Post 25 Sep 2009 07:30 AM by mshawnharris. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

25 Sep 2009 07:30 AM
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?

Thank you

Acceptable Use Policy