I crated a Report in SQL Server Reporting Services.
The Report uses 1 parameter.
When I exe the Report in my IE it asks me for the parameter and then run fine.
When I use Subscriptions' I can put there my email. And sent it to me. (Work fine to)
I want to send this Report to 600 deferent emails. Each and every one get unique parameter.
I have a table with the emails and the parameter.
1. How can I update or insert Subscriptions using a query?
2. Where can I find a script that will help me to do so?
I tried to insert row into table Subscriptions but the server did not let me do so because OF The key.
I try to update row Parameters, ExtensionSettings and the query failed. It’s an ‘ntext’ column. (Xml)
Can u help me?