Hi Guys, I have one Adhoc Report. This report we Generate Manually and submit to our customer. Now i want to Automate this Report. is any solution for automate the reports? i am using 2008 regards, Chinni

Hi, You can save this report to Report srever and then setup a subscription.- Chintak (My Blog)

Hi Chinni, Since it is an Ad Hoc report, it seems that you created the report in the Report Builder and published it to a report server. In this condition, you can create subscriptions for this report on the report manager (Native mode) or a SharePoint site (SharePoint Integrated mode). A subscription is a standing request to deliver a report at a specific time or in response to an event, and in an application file format that you specify in the subscription. Subscriptions provide an alternative to running a report on demand. On-demand reporting requires that you actively select the report each time you want to view the report. In contrast, subscriptions can be used to schedule and then automate the delivery of a report. In this issue, you can create a Standard Subscription which runs based on a scheduel or create a Data-Driven Subscription which can be triggered by the data update on the report server, and email the subscriptions to your customers. To send subscription emails to your customer, you need to configure the Report Server for E-Mail Delivery. For more information, please see: Configuring a Report Server for E-Mail Delivery For more information about Subscription and how to crtea a Standard subscription, please see Subscription and Delivery How to: Subscribe to a Report Regards, Mike YinMike Yin TechNet Community Support

Hi Chinni, Since it is an Ad Hoc report, it seems that you created the report in the Report Builder and published it to a report server. In this condition, you can create subscriptions for this report on the report manager (Native mode) or a SharePoint site (SharePoint Integrated mode). A subscription is a standing request to deliver a report at a specific time or in response to an event, and in an application file format that you specify in the subscription. Subscriptions provide an alternative to running a report on demand. On-demand reporting requires that you actively select the report each time you want to view the report. In contrast, subscriptions can be used to schedule and then automate the delivery of a report. In this issue, you can create a Standard Subscription which runs based on a scheduel or create a Data-Driven Subscription which can be triggered by the data update on the report server, and email the subscriptions to your customers. To send subscription emails to your customer, you need to configure the Report Server for E-Mail Delivery. For more information, please see: Configuring a Report Server for E-Mail Delivery For more information about Subscription and how to crtea a Standard subscription, please see Subscription and Delivery How to: Subscribe to a Report Regards, Mike YinMike Yin TechNet Community Support

Hello, Check out the links below. It may help you. http://msdn.microsoft.com/en-us/library/ms160334.aspx http://searchsqlserver.techtarget.com/tip/Programming-report-generation-with-SQL-Server-Reporting-Services-2008