Dick Campbell


Is there a way to do this It would be useful to test whether a subsciption works. At the moment I am setting the scheduled time a few minutes ahead and waiting for the report to run.

Subsciptions are also a convenient way to store different parameter settings for a report.

My preference would be to to do this through the Report Server UI (presumably from the subscriptions tab).

Alernatively, being able to call a report (with paramters) from a stored procedure woukd be useful.

Thanks,

Dick Campbell




Re: Manually Triggering Subcriptions


Re: Manually Triggering Subcriptions

Dick Campbell

Thanks. I guess I could write a CLR stored procedure with the server name and the subcription name as parameters. That should make it relatively easy for users to manually trigger a subsciption.

It would be nice to be able to trigger subscriptions from the UI. As I have said, subsciptions provide a way to store different parameter settings for later execution something that many of our customers would value.