November 18, 2009 at 5:19 pm
The following article explains how create a unique file name by using @Timestamp. See http://blogs.msdn.com/eugenebykov/archive/2009/10/05/including-time-stamp-in-subscription-report-file-name.aspx. My question is which other @Variables are available or where can I find more information? I am after a filename like ABC_@Year_@Month and the subscriptions is set the run once a month. I am aware of the SSRS sequence number for duplicates.
November 18, 2009 at 7:05 pm
5409045121009 (11/18/2009)
The following article explains how create a unique file name by using @Timestamp. See http://blogs.msdn.com/eugenebykov/archive/2009/10/05/including-time-stamp-in-subscription-report-file-name.aspx. My question is which other @Variables are available or where can I find more information? I am after a filename like ABC_@Year_@Month and the subscriptions is set the run once a month. I am aware of the SSRS sequence number for duplicates.
The defined subscription setting includes Weekly reoccuring so you need to change that to monthly, if SSRS rejects it the other option is to manually use the Agent to run your schedule.
http://msdn.microsoft.com/en-us/library/ms154486.aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply