Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Reporting Services by Paul Turley, Todd Bryant, James Counihan, Dave DuVarney; ISBN: 9780764584978
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 11th, 2009, 06:16 AM
Authorized User
 
Join Date: Nov 2003
Location: , , United Kingdom.
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default The selected report is not ready for viewing. The report is still being rendered or a

I have a SQL Server 2005 Reporting Services report with a drill-down 'sub-report'. If the user clicks on the drill-down link once only, the new report displays fine. However if the user clicks on the drill-down link again before the report appears they get the following error:

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

If they then click back and try to select the drill-down link again the error re-appears unless they refresh the page first.

Is there anything I can do to stop this error appearing, or prevent the user from clicking the link twice?

Thanks for your help/
  #2 (permalink)  
Old February 17th, 2009, 03:05 AM
Wrox Author
Points: 183, Level: 3
Points: 183, Level: 3 Points: 183, Level: 3 Points: 183, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: Vancouver, Washington, USA.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default Drill-down/subreport error

This is an unusual error. In your post you said 'drill-down' and 'subreport' (which are two different things.) Are you actually using a subreport with a toggle item? If so, this may be an inefficient design. Is this a drill-through report that uses a report action? Can you reproduce the error in a similar report using one of the AdventureWorks sample databases and upload it for me?

Thx
__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access


Similar Threads
Thread Thread Starter Forum Replies Last Post
viewing MS Access report from VB 6.0 jthadathilm16 Pro VB Databases 1 May 4th, 2006 08:15 PM
dialog display when viewing the report thiNkspAce Crystal Reports 1 March 27th, 2006 01:53 AM
Viewing Crystal Report sorted by CustomerId ronbora Crystal Reports 0 November 18th, 2004 10:07 AM
Controlling Print Option for Excel rendered report nitachil BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 October 25th, 2004 07:34 PM
Datasets and Custom Assemblies Rendered in Report dillig BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 August 11th, 2004 08:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.