Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

cancel executing query Expand / Collapse
Author
Message
Posted Monday, October 22, 2007 12:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 16, 2007 11:59 PM
Points: 2, Visits: 5
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
Post #413276
Posted Monday, October 22, 2007 12:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 4:15 PM
Points: 57, Visits: 195
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
Post #413277
Posted Monday, October 22, 2007 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 16, 2007 11:59 PM
Points: 2, Visits: 5
It's not an option to do this by hand. We want to do this in code (C#, asp.net)
Post #413287
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse