Configure Report Server for e-mail delivery

Hi,
How do I configure report server for e-mail delivery
Thanks> sanvaceswrote
Hi
> How do I configure report server for e-mail deliver
> Thank
Ther are two ypes of subscription
1. Static subscription (I call it
2. Data driven subscription
Steps
1. Open report manage
Start - Programs - Microsoft SQL server - Reporting services -
Report manage
2. Open the particular repor
a. If you want static subscription (ie Just one mail id
1. Click the New subscription butto
2. Fill in the fields with all required value
3. At the end of the page you will have textbox for the
report parameter - Fill the with required valu
4.In the same page there will be Subscription Processin
Option
a. Click the select schedule butto
b. The subscription page appeare
c. Schedule your subscription as required hea
and click ok
d. The in subscription page click o
This steps conforms your subscriptio
Note
1. To make a auto matic subscription running You need to have Sq
server agent running
2. You should have set the reporting services configured for SMT
serve
O
Revert back for any clarificatio|||Hi,
thanks for the response, but I belive I need to configure the report server
config file and that's the area that I'm getting lost, do you know if I could
exchange server instead of outlook account? I was reading about it yesterday
on MSND but is really not clear the process to configure this file. Any help
woulb be appreciated
"mramakrishnanm" wrote:
> > sanvaceswrote:
> Hi,
> > How do I configure report server for e-mail delivery
> >
> > Thanks
> Ther are two ypes of subscriptions
> 1. Static subscription (I call it)
> 2. Data driven subscriptions
> Steps:
> 1. Open report manager
> Start - Programs - Microsoft SQL server - Reporting services -
> Report manager
> 2. Open the particular repore
> a. If you want static subscription (ie Just one mail id)
> 1. Click the New subscription button
> 2. Fill in the fields with all required values
> 3. At the end of the page you will have textbox for the
> report parameter - Fill the with required value
> 4.In the same page there will be Subscription Processing
> Options
> a. Click the select schedule button
> b. The subscription page appeares
> c. Schedule your subscription as required hear
> and click ok.
> d. The in subscription page click ok
> This steps conforms your subscription
> Note:
> 1. To make a auto matic subscription running You need to have Sql
> server agent running.
> 2. You should have set the reporting services configured for SMTP
> server
> Ok
> Revert back for any clarification
>|||I am home sick and I don't have the exact info for you, but let me give you
the concept. You need a SMTP server. Exchange can definitely act as that. I
use a Unix server as mine. You put in the address in the config file (I
always had to use the IP address rather than the name). The other option is
to configure 2003 to be a SMTP server. Then have a dropbox directory where
you deposit the file for delivery and it is picked up and delivered. I have
never done this, I didn't want to make by environment any more complicated
than necessary.
You definitely do not need an outlook account. I am not even sure whether
you can. RS can do two things, it can send mail to a SMTP server (either
anonymously or using a particular username/password) or it can deposit into
a directory where another program picks it up and mails it.
Note that if you are going to use SMTP with a remote computer you really
need to have SP2 installed. It never worked for me until I did that.
Here is a link to another posting of mine using google groups to find it. I
searched google groups for loehle and smtp and found this right away.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/c3da2e72680a975b/5437d4edab8c4a46?lnk=st&q=loehle+smtp&rnum=1&hl=en#5437d4edab8c4a46
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sanvaces" <sanvaces@.discussions.microsoft.com> wrote in message
news:A571EE9F-B9F6-46B3-8C62-29EE02C9AA7E@.microsoft.com...
> Hi,
> thanks for the response, but I belive I need to configure the report
> server
> config file and that's the area that I'm getting lost, do you know if I
> could
> exchange server instead of outlook account? I was reading about it
> yesterday
> on MSND but is really not clear the process to configure this file. Any
> help
> woulb be appreciated
> "mramakrishnanm" wrote:
>> > sanvaceswrote:
>> Hi,
>> > How do I configure report server for e-mail delivery
>> >
>> > Thanks
>> Ther are two ypes of subscriptions
>> 1. Static subscription (I call it)
>> 2. Data driven subscriptions
>> Steps:
>> 1. Open report manager
>> Start - Programs - Microsoft SQL server - Reporting services -
>> Report manager
>> 2. Open the particular repore
>> a. If you want static subscription (ie Just one mail id)
>> 1. Click the New subscription button
>> 2. Fill in the fields with all required values
>> 3. At the end of the page you will have textbox for the
>> report parameter - Fill the with required value
>> 4.In the same page there will be Subscription Processing
>> Options
>> a. Click the select schedule button
>> b. The subscription page appeares
>> c. Schedule your subscription as required hear
>> and click ok.
>> d. The in subscription page click ok
>> This steps conforms your subscription
>> Note:
>> 1. To make a auto matic subscription running You need to have Sql
>> server agent running.
>> 2. You should have set the reporting services configured for SMTP
>> server
>> Ok
>> Revert back for any clarification
>>|||Bruce,
thanks for your help and I hope you get better the google are is a great
area for help and support.
Due to the tigh security in our email server I ending using a third party
software on Microsoft Outlook that work really great you could schedule any
email with attachments with it (from Sperry Software) it only cost $24 and I
just change the report to be saved in a file instead of email. It would be
really nice if the new release will a have a simpler way to send email.
Thanks
"Bruce L-C [MVP]" wrote:
> I am home sick and I don't have the exact info for you, but let me give you
> the concept. You need a SMTP server. Exchange can definitely act as that. I
> use a Unix server as mine. You put in the address in the config file (I
> always had to use the IP address rather than the name). The other option is
> to configure 2003 to be a SMTP server. Then have a dropbox directory where
> you deposit the file for delivery and it is picked up and delivered. I have
> never done this, I didn't want to make by environment any more complicated
> than necessary.
> You definitely do not need an outlook account. I am not even sure whether
> you can. RS can do two things, it can send mail to a SMTP server (either
> anonymously or using a particular username/password) or it can deposit into
> a directory where another program picks it up and mails it.
> Note that if you are going to use SMTP with a remote computer you really
> need to have SP2 installed. It never worked for me until I did that.
> Here is a link to another posting of mine using google groups to find it. I
> searched google groups for loehle and smtp and found this right away.
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/c3da2e72680a975b/5437d4edab8c4a46?lnk=st&q=loehle+smtp&rnum=1&hl=en#5437d4edab8c4a46
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sanvaces" <sanvaces@.discussions.microsoft.com> wrote in message
> news:A571EE9F-B9F6-46B3-8C62-29EE02C9AA7E@.microsoft.com...
> > Hi,
> >
> > thanks for the response, but I belive I need to configure the report
> > server
> > config file and that's the area that I'm getting lost, do you know if I
> > could
> > exchange server instead of outlook account? I was reading about it
> > yesterday
> > on MSND but is really not clear the process to configure this file. Any
> > help
> > woulb be appreciated
> >
> > "mramakrishnanm" wrote:
> >
> >> > sanvaceswrote:
> >> Hi,
> >> > How do I configure report server for e-mail delivery
> >> >
> >> > Thanks
> >>
> >> Ther are two ypes of subscriptions
> >> 1. Static subscription (I call it)
> >> 2. Data driven subscriptions
> >>
> >> Steps:
> >> 1. Open report manager
> >> Start - Programs - Microsoft SQL server - Reporting services -
> >> Report manager
> >> 2. Open the particular repore
> >> a. If you want static subscription (ie Just one mail id)
> >> 1. Click the New subscription button
> >> 2. Fill in the fields with all required values
> >> 3. At the end of the page you will have textbox for the
> >> report parameter - Fill the with required value
> >> 4.In the same page there will be Subscription Processing
> >> Options
> >> a. Click the select schedule button
> >> b. The subscription page appeares
> >> c. Schedule your subscription as required hear
> >> and click ok.
> >> d. The in subscription page click ok
> >> This steps conforms your subscription
> >>
> >> Note:
> >> 1. To make a auto matic subscription running You need to have Sql
> >> server agent running.
> >> 2. You should have set the reporting services configured for SMTP
> >> server
> >>
> >> Ok
> >> Revert back for any clarification
> >>
> >>
>
>