I write out ssrs 2008 or ssrs 2008 r2 reports to a file share using code based upon the link: http://msdn.microsoft.com/en-us/library/ms152787.aspx. I want to write out the reports to a specified higher level directory strucutre and then dynamically write out the reports to lower level directory levels. I want to export the reports in excel and have each report setup in a unique separate excel spreadsheet. So based upon the link listed below, which one of the three methods would you recommend I use and why. The 3 methods are: 1. Develop applications using Microsoft Visual Studio and the Microsoft .NET Framework SDK, 2. Develop applications using the rs utility (RS.exe), the Reporting Services script environment., 3. Develop applications using any SOAP-enabled set of development tools.

Hi Surendra_Thota, Basically, it is recommended to use the first option "Develop applications using Microsoft Visual Studio" to programmatically gain full control to the reporting services. However, this requires more development regarding the Reporting Service. You can refer to the article below for sample codes, Render Method: http://msdn.microsoft.com/en-us/library/aa258532(v=sql.80).aspx Moreover, I think you can try to use File Share Delivery in Reporting Services to achieve your target. When you create a subscription on report manager, and then can deliver the reports to a folder regularly according to your requirement. More details about it, please see the following articles, How to: Subscribe to a Report (Report Manager): http://msdn.microsoft.com/en-us/library/ms157386.aspx Thanks, Eileen