SQL Server Performance Forum – Threads Archive
Using Subscription Information in Report ParameterI want to set up a subscription to glean some of the information from the subscription and use it in the run parameters. For instance, I want to pass the user-id’s from the distribution list into my report as a parameter. How can I get access to this info? I assume I can get the data right from the underlying SQL Server database but for that I would at least need to glean the subscription ID at run time. Thanks!