Solved

Reporting Services error

Posted on 2007-04-05
3
1,605 Views
Last Modified: 2011-09-20
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

0
Comment
Question by:craigdev
3 Comments
 
LVL 14

Accepted Solution

by:
simon_kirk earned 500 total points
ID: 18858510
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question