Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 923

Figure 17-43
The subscription page allows you to choose a specific subscription type. Re-
porting Services 2005 supports two types of subscription delivery — email
and file share. You can build your own subscription delivery mechanisms
through the extensions provided by the Reporting Services platform. In the
subscription page select the Report File Share delivery as shown in Figure
17-43 . You now need to choose a format for the report (PDF, Excel, CSV,
etc.), specify the path where the report needs to be delivered and credentials
to access the file share where the report needs to be delivered. Once you
specify the options for report file share delivery you need to specify when the
report needs to be delivered. The report can be delivered based on a sched-
ule that you define in the subscription page of a shared schedule that was
already defined. Once you specify the delivery options click OK. The report is
then scheduled to be run using SQL Agent and hence you need to have SQL
Agent running on your machine. Reports will be delivered to the file share
based on the defined schedule and the end users can access the reports
from that file share.
The second delivery option is to deliver the reports via email. You need to
setup your mail server configurations on your report server and enable the
email delivery option. Refer to products documentation on setting up the
email delivery option on your report server. Once the email delivery option is
enabled you can choose this option and specify the email addresses for the
TO, CC, and BCC lines along with the delivery schedule.