Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Dev@nlkss
134 Posts |
Posted - 2009-06-02 : 01:31:24
|
Hi All,I have set of daily reports which are to be subscribe to set of emailids for specific times.How do we do by using reporting services.The persons whom am sending may not be having SSRS installed.can we also use send dbmail option.please guide me.$atya.Love All Serve All. |
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-02 : 11:18:14
|
You can set up a data-driven subscription, that these reports can all reference. The reports can be embedded within the email, or perhaps attached as say, a pdf file for example.Talk sense to a fool and he calls you foolish. |
|
|
gedwards
Starting Member
19 Posts |
Posted - 2009-06-02 : 13:45:46
|
Subscriptions can be setup and scheduled by a user if they have access to the site, or by an adminstrator. The recipient does not need SSRS - that is a server product.Depending on the format chosen, they may need Excel for example.Data Driven sucscriptions require Enterprise Edition, and allow the passing of parameters to filter the output, similar to the user choosing the drop downs on the page.There is also some additional setup needed for this.To access subscriptions, go into the report, then click on the New Subscription button and go through the wizard.Greg EGreg E |
|
|
Dev@nlkss
134 Posts |
Posted - 2009-06-02 : 23:35:24
|
Thanks for ur prompt reply.can u please provide me some links which can guide me.$atya.Love All Serve All. |
|
|
|
|
|