I tried scheduling a report to run on a daily basis and store the snapshots for the user in the CRM 2011 system. Doing this was simple as i selected the report in the reports view and did the scheduling.
However the report snapshots were not getting displayed at all and every time i tried to open the snapshot it gave an error saying "The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"
The culprit was the fact that Snapshot isolation was turned on in my reportserver database. To get rid of this error and to allow the snapshots to be running properly i executed the following query on my reportserver databse and i was good to go...
"ALTER DATABASE ReportServer
SET ALLOW_SNAPSHOT_ISOLATION OFF;"
Hope this helps in case you are stuck while trying to schedule the reports in your CRM installation.
~Abhishek
No comments:
Post a Comment