Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

End a running report in Crystal

Status
Not open for further replies.
Sep 16, 2005
191
US
I have a report that is running for 10 minutes now and I want to stop it.Is there a way to end a running report in Crystal? ESC?
 
Hi,
Crystal Reports can be stopped like other Windows programs..click on the x in the upper right corner and when prompted confirm the 'end now' question..

Or open the task manager and stop the Crystal app...


You database connection should then die on its own..


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
It depends upon what "running" means. If the report is at the point where it is reading records (demonstarated at the bottom of the report), then you don't need to nuke Crystal, just hit the little black box icon near the page navigation icons to stop it.

If a report is running for 10 minutes, you may want to make sure that you're passing the SQL to the database, check my FAQ:

faq767-3825

This is dependent upon your Crystal version and database version and connectivity used, something which should always accompany any post.

-k
 
In order for the stop button to work (little black box icon mentioned above), I think you need to select the 'Perform Query Asynchronously' option from File menu -> Report Options.

HTH



Gary Parker
MIS Data Analyst
Manchester, England
 
On a Windows sytem, you can use Task Manager to stop a Crystal run that is going on for a long time and might be showing you just a blank screen. Better to use the right-hand X, of course, but not always possible.

I get this much less, now I've learned how to use Crystal to generate efficient SQL. But sometimes business users need something quite complex and a long run is necessary.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top