locked
ReportViewer- WebForms - Cancel Button Issue RRS feed

  • Question

  • Hello, 

    I am using the webform ReportViewer control tool as seen below

        <body style="margin:0px; background-color:white;">
            <form id="form1" runat="server">
            <asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeout="3600" AsyncPostBackErrorMessage="No">
            </asp:ScriptManager>
            <div style="height: 100vh; ;">
                <rsweb:ReportViewer ID="reportViewer"  runat="server" Width="100%" Height="100%"></rsweb:ReportViewer>
            </div>
                </form>
        </body>

     

    I noticed very often that there is a major delay in killing the query running in the underlying datasource when clicking on the "Cancel" button while report is still rendering/spinning. Is there a way to stop/kill these queries faster? I have some pretty expensive queries running and would like to kill them as soon as possible.

     

    Tuesday, November 3, 2020 11:45 PM