<div>
<div class="content wysiwyg-content">
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 
 

</div>
</div>

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



Reporting Services error

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.