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 |
|
spark58510
Starting Member
4 Posts |
 Posted - 2005-04-27 : 00:10:33
|
| I'm building a data-driven subscription to generate production reports for doctors. I specify a data source/query for the recipient and parameter information. I know that globals can be included in the email subject, but can information from the query be included as well?i.e.@ReportName for @DoctorsName from @startDate to @endDateThanks, |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-27 : 08:59:50
|
Hey spark,Not unless you create your own assembly (basically your own app) to use the contents of that query to modify the subject line of your email. There is nothing right now in RS alone that will allow you to change it.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
spark58510
Starting Member
4 Posts |
Posted - 2005-04-27 : 10:53:59
|
| I guess a workaround is including the dynamic subject line in your query and mapping the subject line to that dataset field. I'm building a database for data-driven subscriptions anyway. |
|
|
|
|
|
|
query parms in email subj