Hello everyone, I am hoping to get some ideas and avoid going down the wrong track with some reports I am working on. We are running SQLServer 2008 Standard and I need to set up subscriptions for 2 different reports. Data-driven subscriptions would be ideal but that option is not available in Standard and we are not upgrading to Enterprise edition any time soon. Both reports need to accept parameters to pass to procedures that get the data for the report. One of the parameters also needs to be used to determine where the report should be saved and what file name to use in the directory. The reports need to be exported to Excel before they are saved in a directory on a network drive. I have been searching and reading for days now and have found little to nothing on the subject that would lead to a solution. There is a post showing how to get around the problem with the prompt when SSRS exports a report to PDF, which could work for Excel exports, but it is shown as a web application. I am not sure if a web appliation is the best way to get my reports delivered since they have to run on a schedule. Have you found a way to implement a data-driven subscription in SSRS 2008 standard? HOw? Have you found a tool to buy that helps with this? I'd love to hear about it. Any and all help is greatly appreciated Thanks all

Hi UteW, Since the DDS is not available on SQL Server standard, i would suggest you upgrade to Enterprise edition. There is no built-in workaround to achieve this except you custom such an extension to do it with .net lanaguage, but that is a heavy work and require good programming skill. thanks, Jerry