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
Yes, but not through the UI as far as I know.
Look at this http://msdn2.microsoft.com/it-it/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.fireevent.aspx
|||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.
No comments:
Post a Comment