hi there: I have a request from a client for a report subscription. What he wants is to auto run a report based on a marketing campaign. When 8 weeks between today and the created date of that campaign elapsed, he wants to receive the excel file of this report. I am thining about the data driven subscription. But , how to trigger the report to run when it hits 8 weeks? Any ideas? thanks hui--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

hi, there, I kinda figure out the whole procedure. Do I need to configure the History section or Execution in order to activate the data driven subscription. Also , do I have to provide a default value of the report parameter ? the parameter should be provided via a query. many thanks Hui--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

Hi cat_ca, Glad to know that you have worked out the previous requirements. As for your new queries, please check follows, Q: Do I need to configure the History section or Execution in order to activate the data driven subscription? A: No, they are not a must for data driven subscription. On the history tab, we can set the properties of the history of the reports. For example, how many snapshots of a report will be stored in the database and how often. On the Execution tab, a report can fetch its data from the database the moment it's a executed or from a cache which is refreshed after an interval you specify on this tab. Appearently, the performance of the report execution could be improved if the data is fetched from a cache. Q: Do I have to provide a default value of the report parameter ? A: It depends on your requirement. During the subscription progress, the Report Manager would ask for a value if no default value was specified. For more details, please refer to the article below, Data-Driven Subscriptions: http://msdn.microsoft.com/en-us/library/ms159150.aspx Create Data-driven Subscription Page (Report Manager): http://msdn.microsoft.com/en-us/library/ms187066.aspx Thanks, Eileen