Post reply

cancel executing query

  • 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

  • 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

  • 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)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply