I am running SQL Server 2000 sp4 and Reporting Services 2000 sp2. I set
up a data driven subscription with a static Reply-To address. However,
when the report runs, the reply is the default in the config file.
I've seen 1 other post on this but no solution. Help would be
appreciated.
NeilI captured this info using SQL Profiler:
exec CreateSubscription @.Report_Name =N'/WebInvoiceStatus_Reports/VendorActivity', @.id ='86750772-3D96-4059-8B1E-9F5F5D6C8000', @.OwnerSid =0x01050000000000051500000093E362480D7A5A33828BA628CA300100, @.OwnerName
= N'US\A0312698', @.OwnerAuthType = 1, @.Locale = N'en-US',
@.DeliveryExtension = N'Report Server Email', @.InactiveFlags = 0,
@.ExtensionSettings =N'<ParameterValues><ParameterValue><Name>TO</Name><Field>EmailAddress</Field></ParameterValue><ParameterValue><Name>ReplyTo</Name><Value>aphelp@.abcdef.com</Value>...
This shows that the value I wanted was being picked up. So I wonder if
the problem is with the smtp.
Neil|||My issue is not with the 'Reply-To' I just discovered.
It is the 'From' that I have been trying to change and that cannot be
done for each subscription.
The From did change when I changed it in the config file.
I love solving my own problems.
Neil
Friday, March 9, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment