The selected report is not ready for viewing. The report is still being rendered or a

gp_mk · February 11th, 2009, 06:16 AM

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/

Paul_Turley · February 17th, 2009, 03:05 AM

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