Reporting Services error

I am trying to get Reporting Services working on our SQL Server 2005 server. Report Manager is running, I can login and add reports and data sources. When I open a report in Report Manager the parameter fields display however when I click View Report this error comes up:

The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)

We are not using snapshots or anything like that. For testing I made a very simple report that displays the contents of a small database table.

Any ideas?


-- Ive tried this already, no difference
ALTER DATABASE ReportServer
SET ALLOW_SNAPSHOT_ISOLATION OFF

ALTER DATABASE ReportServer
SET READ_COMMITTED_SNAPSHOT OFF

ALTER DATABASE ReportServerTempDB
SET ALLOW_SNAPSHOT_ISOLATION OFF

ALTER DATABASE ReportServerTempDB
SET READ_COMMITTED_SNAPSHOT OFF

LVL 1
craigdevAsked:
Who is Participating?
 
simon_kirkConnect With a Mentor Commented:
Hi.
This worked for someone else who had a similar problem:.
In SQL Server Management Studio, connect to each Reporting Services instance, navigate to each report.
Right click each report, select the Execution page, and make sure "Render this report with the most recent data" and "Cache the report. Expire after (minutes)" is checked.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.