Dynamic File name creation in subscription
-
Is there any way to get the subscription file name creation dynamic, for example to customize file name in kind of pattern like 'ReportName_parameter1'.xls?
-
I have looked into this as well. The only way I have found that this can be done is to create a data-driven subscription which will provide the File Name.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
I was searching for this option as well, but when sending an email or with the data driven subscription. You can do it when using file-share, but still is not so flexible.
Could you explain in more details how are you doing it with data-driven subscrioption, as you said. Would I be able to append getdate() at the end of the file name, or text dependable on parameter?
Thank you!
Elizabeta
-
First, you need enterprise SQL 2005 with reporting service.
Then you can design a SQL statement, and any field in the SQL statement could be use as parameter in your reports.
Get more detail from Microsoft's tutorial http://msdn2.microsoft.com/en-us/library/ms169673.aspx
-
This doesn't address the filename, but you don't need the Enterprise version...
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply