Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Dynamic path for target folder Expand / Collapse
Author
Message
Posted Friday, February 27, 2009 4:06 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:28 PM
Points: 77, Visits: 606
Hello,

I have a monthly report that needs to be delivered to a file share. The catch is...the folder is different every month. The folder already exists and its name is based on the date. eg... \\server\d$\reports\03012009.

I need to to automate this report in SSRS. Is there any way to dynamically populate the path to the target folder?

Thanks
Post #666056
Posted Wednesday, January 16, 2013 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 3, 2013 12:38 PM
Points: 4, Visits: 133
Create a stored procedure and call create the path in that proc. Call the proc from the subscription selecting the Path.
Anil Madan
Post #1407875
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse