I know to create a file share directory using the standard edition of sql server 2008 r2, I would use the following link: http://msdn.microsoft.com/en-us/library/ms157386.aspx. However, I still have the following question: 1. For writing to the file share directory, I want to be able to write to a directory structure that has three levels. The file share directory would look like: a. higher level would be region like midwest, east-coast, and west-coast. b. The middle level would be state level like Iowa, Ohio, oregon, california, etc... c. The third level would be the city name like Council bluffs (which is in Iowa and higher level would be the midwest). Another example would be the city of Anaheim (which is in California which is in the west-coast.) To be able to store files in this directory strucutre, could I accomplish task using a standard subscription? If so is there a url you can point me to that would give more details? If not, would one of the following two choices be an option: - Write a .net application that would accomplsih this task for me? If so, do you have a url I can look at for a reference? If not, I will look on the internet to see how to write this .net code and/or would you recommend what forum group would I ask this question to? - Would setting up the standard subscription to e-mail addresses help and then use the e-mail addresses to write the file to reports to the file share work?

asked twice accidently

afaik you cannot output a report to a different file share based on the results/data within the report.

I do not understand your answer. please explain better

I'm assuming you wish to save the report into a particular directory based on the data in the report. If so, this is not possible. When a subscription is created it needs to be configured to save to a particular directory.

Hi Wendy, As Stephen posted, when a subscription is created, it needs to be configured to save to a particular directory (an existing shared folder). In other words, it is not possible to write to a directory structure in a file shared subscription. However, one approach to accomplish this task is to write a .net application as you suggested. Generally, we can use the basic file I/O feature of .NET Framework to create directory. And we also integrate the Report Server Web Service into the .net application to access and export report. For more information about Basic File I/O in .NET Framework, please refer to: http://msdn.microsoft.com/en-us/library/336wast5.aspx About Report Server Web Service, please refer to: http://msdn.microsoft.com/en-us/library/ms152787.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Tony Chain: In one of you previous posts, I unserstood you could write to a file share directory by referrring to the to the url: http://msdn.microsoft.com/en-us/library/ms157386.aspx. Hoewver in the above statement you said 'I could not save to a 'directory structure in a file shared subscription'. Would you explain what you mean by this? Also thank you for your reference about the .net application listed above. I will probably be taking your advise on the .net application!

Hi Wendy, Sorry for the confusion. Generally, each file share subscription can only deliver report to a particular folder. It cannot deliver report to a directory structure with levels dynamically. In order to deliver one report to multiple folders, first we need created the directory structure with levels manually, and then create multiple subscriptions to deliver report to each particular folder. Since this approach is static, it might not meet your requirement. So, I would suggest you build a custom .net application. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.