Solved

SSRA Subscription, Need PATH to include YEAR as parameter

Posted on 2014-12-24
4
91 Views
Last Modified: 2015-05-16
My SSRS (SQL2012) subscription copies a report to a Windows File Share and the path to that destination includes the year. (i.e. \\machinename\share\folder\2014\Folder).  

Each Year I have to change that path on Dec 31. Is there a way to have the YEAR be a parameter in the PATH dialog so it updates when needed?
Bonus points if SSRS could create the directory as needed if it didn't already exist.
0
Comment
Question by:Salad-Dodger
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
Russell Fox earned 500 total points
ID: 40519138
Sadly, no, that's not possible in vanilla SSRS:
When defining a subscription that uses file share delivery, you must specify an existing folder as the target folder. The report server does not create folders on the file system. -MSDN - File Share Delivery
It may be possible to change the subscription with an Agent job that runs once a year, but MS has deeply obfuscated the SSRS subscription information in the ReportServer databases. You could probably accomplish this with some C# code using the ReportViewer control, but that's deep magic.
0
 
LVL 1

Author Comment

by:Salad-Dodger
ID: 40519261
Well, thats a bummer, but not unexpected.
Assuming the year path exists, what about the part where I can alter the path entry in the SSRS subscription through code? Perhaps there is some way to use the parameter from which the report is generated?
0
 
LVL 1

Author Closing Comment

by:Salad-Dodger
ID: 40741397
Sigh - -  Foiled again.
0
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40780989
Sorry, didn't see you next comment. Here's an article on how to do something using SSIS: complicated, but might work. http://geekswithblogs.net/LifeLongTechie/archive/2009/11/24/calling-ssrs-report-using-either-t-sql-or-ssis.aspx
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question