email notifications scheduled jobs

In the notifications tab of the job I have e-mail operator selected. Click on the box with the elipses to enter the email addresses. It will let me enter 2 email addresses in the e-mail name field. It looks like the field has a limited length...is there a way to manually enter several addresses?http://www.sqlmag.com/Article/ArticleID/21450/sql_server_21450.html
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=31

Email From address needs to change

Does anyone know how to run reporting services so it can change the From
address for each report it sends. I need to use mutiple From addresses
depending what the report is.Could someone please reply to this posting as I need to know the answer as
well :-)
Thank you,
Lisa
"gamsql" wrote:
> Does anyone know how to run reporting services so it can change the From
> address for each report it sends. I need to use mutiple From addresses
> depending what the report is.

E-mail failure in data driven subscriptions

When using a data driven subscription to generate and send a number or
reports to different addresses I have only been able to find a number that
were successful or failed. Is there any way to tell specifically which
e-mails from the group failed?The ReportServerService<timestamp>.log file will contain the information.
There is no UI around this information.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwray" <bwray@.discussions.microsoft.com> wrote in message
news:021B7E1F-76F7-4932-9448-7B79EF561763@.microsoft.com...
> When using a data driven subscription to generate and send a number or
> reports to different addresses I have only been able to find a number that
> were successful or failed. Is there any way to tell specifically which
> e-mails from the group failed?|||Thanks. That helped to some degree. I still can't find which indivdual
e-mail within the batch failed. I set up a controlled report scenario in
which I knew two of the e-mails would fail. However, the indivdual entrees
in the execution log all had a 'rssuccess' status for the report. The 'last
run status' in the schedule table shows '2 of 3 comlete with 2 errors'. I
know which ones failed, I just can't seem to pinpoint them within the logs.
Am I on the right track or am I looking in the wrong place? Thanks.
"Daniel Reib [MSFT]" wrote:
> The ReportServerService<timestamp>.log file will contain the information.
> There is no UI around this information.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bwray" <bwray@.discussions.microsoft.com> wrote in message
> news:021B7E1F-76F7-4932-9448-7B79EF561763@.microsoft.com...
> > When using a data driven subscription to generate and send a number or
> > reports to different addresses I have only been able to find a number that
> > were successful or failed. Is there any way to tell specifically which
> > e-mails from the group failed?
>
>|||You should look in the log files for something like the following:
Notification <guid> completed. Success: True, Status: Mail sent to
<address>, DeliveryExtension: Report Server Email, Report: <report name>,
Attempt 0
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwray" <bwray@.discussions.microsoft.com> wrote in message
news:C99702B8-05E3-46FC-B7F5-A450289EF8DF@.microsoft.com...
> Thanks. That helped to some degree. I still can't find which indivdual
> e-mail within the batch failed. I set up a controlled report scenario in
> which I knew two of the e-mails would fail. However, the indivdual
> entrees
> in the execution log all had a 'rssuccess' status for the report. The
> 'last
> run status' in the schedule table shows '2 of 3 comlete with 2 errors'.
> I
> know which ones failed, I just can't seem to pinpoint them within the
> logs.
> Am I on the right track or am I looking in the wrong place? Thanks.
> "Daniel Reib [MSFT]" wrote:
>> The ReportServerService<timestamp>.log file will contain the information.
>> There is no UI around this information.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "bwray" <bwray@.discussions.microsoft.com> wrote in message
>> news:021B7E1F-76F7-4932-9448-7B79EF561763@.microsoft.com...
>> > When using a data driven subscription to generate and send a number or
>> > reports to different addresses I have only been able to find a number
>> > that
>> > were successful or failed. Is there any way to tell specifically which
>> > e-mails from the group failed?
>>|||Thanks again. I think I'm getting closer to what I'm looking for but I'm
still not there. The 'To:' address for e-mails that fail is not available in
the log file. Now I can tell by recipient / time which ones were
successful. Now the problem is that if multiple copies of the same named
report go out in close proximity to each other (think invoices) I can't tell
which one fails.
"Daniel Reib [MSFT]" wrote:
> You should look in the log files for something like the following:
> Notification <guid> completed. Success: True, Status: Mail sent to
> <address>, DeliveryExtension: Report Server Email, Report: <report name>,
> Attempt 0
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bwray" <bwray@.discussions.microsoft.com> wrote in message
> news:C99702B8-05E3-46FC-B7F5-A450289EF8DF@.microsoft.com...
> > Thanks. That helped to some degree. I still can't find which indivdual
> > e-mail within the batch failed. I set up a controlled report scenario in
> > which I knew two of the e-mails would fail. However, the indivdual
> > entrees
> > in the execution log all had a 'rssuccess' status for the report. The
> > 'last
> > run status' in the schedule table shows '2 of 3 comlete with 2 errors'.
> > I
> > know which ones failed, I just can't seem to pinpoint them within the
> > logs.
> > Am I on the right track or am I looking in the wrong place? Thanks.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> The ReportServerService<timestamp>.log file will contain the information.
> >> There is no UI around this information.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "bwray" <bwray@.discussions.microsoft.com> wrote in message
> >> news:021B7E1F-76F7-4932-9448-7B79EF561763@.microsoft.com...
> >> > When using a data driven subscription to generate and send a number or
> >> > reports to different addresses I have only been able to find a number
> >> > that
> >> > were successful or failed. Is there any way to tell specifically which
> >> > e-mails from the group failed?
> >>
> >>
> >>
>
>|||I'm not sure what the issue might be. Each row from the DataDriven
subscription will create a new notification row. Each of these rows are
handled individually. I am not sure why you are not seeing the results.
You could send me the log file and I could take a look if you like. Just
remove the online from my address.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwray" <bwray@.discussions.microsoft.com> wrote in message
news:90179329-413F-425F-8D8F-FD97876F94FE@.microsoft.com...
> Thanks again. I think I'm getting closer to what I'm looking for but I'm
> still not there. The 'To:' address for e-mails that fail is not available
> in
> the log file. Now I can tell by recipient / time which ones were
> successful. Now the problem is that if multiple copies of the same named
> report go out in close proximity to each other (think invoices) I can't
> tell
> which one fails.
> "Daniel Reib [MSFT]" wrote:
>> You should look in the log files for something like the following:
>> Notification <guid> completed. Success: True, Status: Mail sent to
>> <address>, DeliveryExtension: Report Server Email, Report: <report name>,
>> Attempt 0
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "bwray" <bwray@.discussions.microsoft.com> wrote in message
>> news:C99702B8-05E3-46FC-B7F5-A450289EF8DF@.microsoft.com...
>> > Thanks. That helped to some degree. I still can't find which indivdual
>> > e-mail within the batch failed. I set up a controlled report scenario
>> > in
>> > which I knew two of the e-mails would fail. However, the indivdual
>> > entrees
>> > in the execution log all had a 'rssuccess' status for the report. The
>> > 'last
>> > run status' in the schedule table shows '2 of 3 comlete with 2
>> > errors'.
>> > I
>> > know which ones failed, I just can't seem to pinpoint them within the
>> > logs.
>> > Am I on the right track or am I looking in the wrong place? Thanks.
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> The ReportServerService<timestamp>.log file will contain the
>> >> information.
>> >> There is no UI around this information.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "bwray" <bwray@.discussions.microsoft.com> wrote in message
>> >> news:021B7E1F-76F7-4932-9448-7B79EF561763@.microsoft.com...
>> >> > When using a data driven subscription to generate and send a number
>> >> > or
>> >> > reports to different addresses I have only been able to find a
>> >> > number
>> >> > that
>> >> > were successful or failed. Is there any way to tell specifically
>> >> > which
>> >> > e-mails from the group failed?
>> >>
>> >>
>> >>
>>

Email delivery, rendering format problem

Hi,

Im trying to set up so the report gets delivered to specified email addresses with the rendering format set to Web Archive.

The problem is, it wont deliver the background of the report. We really need the background to be yellow (company color) i have tried with both the backgroundcolor setting and backgroundimage setting with repeat =true, but it just delivers the email as transparent(white) background.

Anyone know how to solve this?

regards,
xenojust seem like it is impossible. For those with similiar problem in the future, here is the work-around that i used:
Put a rectangle on your form that stretches 100% with and height of the form and put all objects within it. Make sure it will be resizable to fit.

I dont like it at all, but hey...cant waste too much time on these things when the clock is ticking.
.xeno

email addresses

Is there a way inside the subscription to hide the email addresses. I have
a report that I need sent out to about 20 people but I dont want them to be
able to view one anothers addresses. And I would rather not create 20
different subscriptions. ThanksIn the Report Delivery Options can you email the report to yourself, then
add everyone else under Bcc?
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:ewzYLGGyGHA.4392@.TK2MSFTNGP04.phx.gbl...
> Is there a way inside the subscription to hide the email addresses. I
> have a report that I need sent out to about 20 people but I dont want them
> to be able to view one anothers addresses. And I would rather not create
> 20 different subscriptions. Thanks
>|||Thanks, that works great.
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:OowMq6GyGHA.4024@.TK2MSFTNGP02.phx.gbl...
> In the Report Delivery Options can you email the report to yourself, then
> add everyone else under Bcc?
>
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:ewzYLGGyGHA.4392@.TK2MSFTNGP04.phx.gbl...
>> Is there a way inside the subscription to hide the email addresses. I
>> have a report that I need sent out to about 20 people but I dont want
>> them to be able to view one anothers addresses. And I would rather not
>> create 20 different subscriptions. Thanks
>

Email address disappears in subscription

When I am in a subscription for a report in RS (SP1 installed) and I click on
Select Schedule, and then click on OK, any email addresses that I had in the
subscription are gone. Any addresses that I have in the Cc: or Bcc: are still
there but the To: list is empty.
Is this normal?No, this is not normal. Does the subscription work normally if you enter
the to field after setting the subscription? I am not really sure what
would cause some of the fields to stay but others not. Does this happen for
every user?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"garyc" <garyc@.discussions.microsoft.com> wrote in message
news:B1716E77-31E6-469E-9A41-35E1871975E6@.microsoft.com...
> When I am in a subscription for a report in RS (SP1 installed) and I click
on
> Select Schedule, and then click on OK, any email addresses that I had in
the
> subscription are gone. Any addresses that I have in the Cc: or Bcc: are
still
> there but the To: list is empty.
> Is this normal?|||In answer to your first question yes, the To: name does stay after you retype
it.
And yes this does happen for every user.
Gary
"Daniel Reib [MSFT]" wrote:
> No, this is not normal. Does the subscription work normally if you enter
> the to field after setting the subscription? I am not really sure what
> would cause some of the fields to stay but others not. Does this happen for
> every user?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "garyc" <garyc@.discussions.microsoft.com> wrote in message
> news:B1716E77-31E6-469E-9A41-35E1871975E6@.microsoft.com...
> > When I am in a subscription for a report in RS (SP1 installed) and I click
> on
> > Select Schedule, and then click on OK, any email addresses that I had in
> the
> > subscription are gone. Any addresses that I have in the Cc: or Bcc: are
> still
> > there but the To: list is empty.
> >
> > Is this normal?
>
>|||I'm not sure what would cause this behavior. My only guess would be that
perhaps you have an IE extension that is clearing it out for you (something
like the google toolbar). The fact that the other elements are working
correctly seems to indicate the issue is outside of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"garyc" <garyc@.discussions.microsoft.com> wrote in message
news:04FD1470-A465-4441-AA44-517163231D6B@.microsoft.com...
> In answer to your first question yes, the To: name does stay after you
retype
> it.
> And yes this does happen for every user.
> Gary
>
> "Daniel Reib [MSFT]" wrote:
> > No, this is not normal. Does the subscription work normally if you
enter
> > the to field after setting the subscription? I am not really sure what
> > would cause some of the fields to stay but others not. Does this happen
for
> > every user?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "garyc" <garyc@.discussions.microsoft.com> wrote in message
> > news:B1716E77-31E6-469E-9A41-35E1871975E6@.microsoft.com...
> > > When I am in a subscription for a report in RS (SP1 installed) and I
click
> > on
> > > Select Schedule, and then click on OK, any email addresses that I had
in
> > the
> > > subscription are gone. Any addresses that I have in the Cc: or Bcc:
are
> > still
> > > there but the To: list is empty.
> > >
> > > Is this normal?
> >
> >
> >|||Daniel,
FWIW, I am experiencing the same issue as Gary when creating a subscription.
The To field gets cleared out every time I click the Select Schedule
button - all others remain. It happens consistently across browsers and
client machines. Not a show-stopper, but pretty annoying to say the least.
<g>
I have the following setting in RSReportServer.config:
<SendEmailToUserAlias>False</SendEmailToUserAlias>
When this is True, the field does not seem to get cleared out (maybe because
it's disabled?).
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Daniel Reib [MSFT] wrote:
> I'm not sure what would cause this behavior. My only guess would be
> that perhaps you have an IE extension that is clearing it out for you
> (something like the google toolbar). The fact that the other
> elements are working correctly seems to indicate the issue is outside
> of RS.
>
> "garyc" <garyc@.discussions.microsoft.com> wrote in message
> news:04FD1470-A465-4441-AA44-517163231D6B@.microsoft.com...
>> In answer to your first question yes, the To: name does stay after
>> you retype it.
>> And yes this does happen for every user.
>> Gary
>>
>> "Daniel Reib [MSFT]" wrote:
>> No, this is not normal. Does the subscription work normally if you
>> enter the to field after setting the subscription? I am not really
>> sure what would cause some of the fields to stay but others not.
>> Does this happen for every user?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "garyc" <garyc@.discussions.microsoft.com> wrote in message
>> news:B1716E77-31E6-469E-9A41-35E1871975E6@.microsoft.com...
>> When I am in a subscription for a report in RS (SP1 installed) and
>> I click on Select Schedule, and then click on OK, any email
>> addresses that I had in the subscription are gone. Any addresses
>> that I have in the Cc: or Bcc: are still there but the To: list is
>> empty.
>> Is this normal?|||Ah ha. Looks like that is the key element. I have been able to reproduce
the problem and it is a bug. I will file it so that it can get fixed.
Thanks for helping us out.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:ulKvLeIsEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Daniel,
> FWIW, I am experiencing the same issue as Gary when creating a
subscription.
> The To field gets cleared out every time I click the Select Schedule
> button - all others remain. It happens consistently across browsers and
> client machines. Not a show-stopper, but pretty annoying to say the
least.
> <g>
> I have the following setting in RSReportServer.config:
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> When this is True, the field does not seem to get cleared out (maybe
because
> it's disabled?).
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> Daniel Reib [MSFT] wrote:
> > I'm not sure what would cause this behavior. My only guess would be
> > that perhaps you have an IE extension that is clearing it out for you
> > (something like the google toolbar). The fact that the other
> > elements are working correctly seems to indicate the issue is outside
> > of RS.
> >
> >
> > "garyc" <garyc@.discussions.microsoft.com> wrote in message
> > news:04FD1470-A465-4441-AA44-517163231D6B@.microsoft.com...
> >> In answer to your first question yes, the To: name does stay after
> >> you retype it.
> >>
> >> And yes this does happen for every user.
> >>
> >> Gary
> >>
> >>
> >> "Daniel Reib [MSFT]" wrote:
> >>
> >> No, this is not normal. Does the subscription work normally if you
> >> enter the to field after setting the subscription? I am not really
> >> sure what would cause some of the fields to stay but others not.
> >> Does this happen for every user?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "garyc" <garyc@.discussions.microsoft.com> wrote in message
> >> news:B1716E77-31E6-469E-9A41-35E1871975E6@.microsoft.com...
> >> When I am in a subscription for a report in RS (SP1 installed) and
> >> I click on Select Schedule, and then click on OK, any email
> >> addresses that I had in the subscription are gone. Any addresses
> >> that I have in the Cc: or Bcc: are still there but the To: list is
> >> empty.
> >>
> >> Is this normal?
>|||Have you gotten any solution? I got the same problem.|||I have the same issue. Have you gotten any solutions?



Thanks.