SSRS Dynamic path for target folder

• brickpack

  SSCrazy

  Points: 2702

  More actions

  February 27, 2009 at 4:06 pm

  #206351

  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

• amadan

  Newbie

  Points: 6

  More actions

  January 16, 2013 at 8:29 am

  #1577855

  Create a stored procedure and call create the path in that proc. Call the proc from the subscription selecting the Path.

  Anil Madan