cancel executing query

• Gaby Lever-314483

  SSC Enthusiast

  Points: 124

  More actions

  October 22, 2007 at 12:35 am

  #92746

  We are using Crystal Reports for creating reports for our website. When an user selects a report a new window opens and the crystal report is starting to generate. The sql query is executing on our database. When the user closes the window the query is still executing up to serveral minutes. So is there a way to cancel the query when the user is closing the browse.

  Thx in advance

  Greetings

• okhere

  SSC-Addicted

  Points: 443

  More actions

  October 22, 2007 at 12:40 am

  #744008

  Hi,

  Go to the homepage of your Reporting Services:

  http://yourservername/reports/Pages/Folder.aspx

  then Site Settings (on the far top right)

  then Manage Jobs (on the bottom left)

  you can then kill any process that is currently active.

  I hope that helps.

  Thanks

  Osama

• Gaby Lever-314483

  SSC Enthusiast

  Points: 124

  More actions

  October 22, 2007 at 1:19 am

  #744015

  It's not an option to do this by hand. We want to do this in code (C#, asp.net)