Is it possible to trigger a subscription using url access to SSRS? And how can I deliver a report to the ftp server using subscription?
View Complete Post
Hi All, i discover an issue for reporting subscription, since look like very ccommon but i still cant find a good solution, please help
SQL version: SQL version 2000
issue: I am trying to get a time subscription for a report to work. The SQL Agent
job is created, and runs successfully. The ReportServer.dbo.AddEvent sp is
run and add record to the "event" table in the ReportServer datanase, but
event appears to never be executed by the ReportServer. How do I verify that
the Report Server is actually polling this table to verify whether or not
there are events to run.
I have a serious problem that cannot be solved by googling around the keywords below: sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....
The error is;
"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "
Everything is O.K.;
* When I render the report from the REPORTSERVER (http://localhost/ReportServer) * When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007)ÃÂ
But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above.ÃÂ
It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameterÃÂ and order "apply/report"...
Possible causes how I met that error may be;
After I have installed (then uninstalled) AJAX extensions After I have re-configured IIS Web Service Extensions list items
Possible solution alternatives I've found;
I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol