Can report parameters be sent in subscription emails?

Hi all,
Is there any way to have the report parameters appear in the subscription
email, for both custom and default reports? Currently, the goal is to just
get the team project name to appear along with the sent report. The other
idea I can think of is to just put a field in the actual report that will
show the project name. I would rather not do this so that we don't have to
edit the existing rdl's (unless in the end, we absolutely have to). It
would also appear redundant when viewing the reports through Report Manager.
In addition to these, it is possible that people would request for other
parameters to be sent with the email, thus cluttering the actual report with
redundant information.
Can anyone help or offer alternatives, please? Thanks.Hello Winkles,
I would like to know this issue a little bit clearly.
Do you mean that you want to add the Report Parameter in the Subject of the
subscription?
Well, you could not refer the Report Parameter in the Subject.
I would like to suggest you to use the data driven subscription so that you
could store the subject in a data table and you could maintain it.
Data-Driven Subscriptions
http://msdn2.microsoft.com/en-us/library/ms159150.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
We are trying to include, at the very least, the team project name in the
email somewhere. This is because some people may subscribe to the same
report across multiple team projects, and we need a way to indicate which
project the report belongs to.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:dllA96K$GHA.4432@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> I would like to know this issue a little bit clearly.
> Do you mean that you want to add the Report Parameter in the Subject of
> the
> subscription?
> Well, you could not refer the Report Parameter in the Subject.
> I would like to suggest you to use the data driven subscription so that
> you
> could store the subject in a data table and you could maintain it.
> Data-Driven Subscriptions
> http://msdn2.microsoft.com/en-us/library/ms159150.aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Winkles,
Thanks for the update.
When you try to create a subscription, you will need to provide which
parameter you will need to render the report.
According to your scenario, you could add a TextBox in the beginning of the
report and add the value =Parameters!Team.Value in the textbox. Then, when
you send the email, and provide the parameter value, it will show the value
in the report.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
Thanks for your response. So is that the only way to do it then? Adding a
textbox to the report? There is no way to either set some flag or add some
lines of code to get something like the Parameters selection box to be sent
with the subscription email, along with the options used to generate that
report?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:a8xSHiY$GHA.4184@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> Thanks for the update.
> When you try to create a subscription, you will need to provide which
> parameter you will need to render the report.
> According to your scenario, you could add a TextBox in the beginning of
> the
> report and add the value =Parameters!Team.Value in the textbox. Then, when
> you send the email, and provide the parameter value, it will show the
> value
> in the report.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Just to clarify: will this change also be applied to people who subscribe to
their own reports, i.e. independent of a data-driven subscription?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:a8xSHiY$GHA.4184@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> Thanks for the update.
> When you try to create a subscription, you will need to provide which
> parameter you will need to render the report.
> According to your scenario, you could add a TextBox in the beginning of
> the
> report and add the value =Parameters!Team.Value in the textbox. Then, when
> you send the email, and provide the parameter value, it will show the
> value
> in the report.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Winkles,
If you wants the user to be able to select the parameter in the email
subscription, that can not been done in the Reporting Services.
All the report render type need a parameter value so you could not just
provide the parameter select option in the output file.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Can notification services record bounced emails automatically?

Hi,

I've not used SSNS yet but am considering it for an up coming project.

One of the criteria is that "SMTP delivery failures are to be recorded against the recipients".

Is this something that happens "out of the box" with SSNS? If not would it be difficult to write something to do it?

Cheers for any advice.

Martin

Try this posting....

http://groups.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/d86305394d873284/cecc579ef585b9da?lnk=gst&q=kate+bounce+email&rnum=1#cecc579ef585b9da

HTH...

Joe