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?