locked
Not able to open excel after exporting to excel, multiple times . RRS feed

  • Question

  • User1648372490 posted

    I am trying to export to excel using SSRS reports , its working fine with pdf ,but while exporting to excel ,if i want to export multiple times the excel is not opening after 2-3 times. I am using MS Excel 2010. Help me....

     

     

     

     

    Friday, May 13, 2011 8:07 AM

All replies

  • User1471008070 posted

    Hi,

    You mentioned it does not work?Could you please clarify your scenario? does it have some error message? detail information is a big help for us to troubleshooting.

    Thanks,
    Challen Fu

    Tuesday, May 17, 2011 6:18 AM
  • User1629046272 posted

    Hi,

    It seems due to "Response.End", to overcome you can include the following javascript in aspx page.

    function EnableExport()
    {

    window.WebForm_OnSubmit = function()
                          {return true;};
    }
    Then, call on client click of the asp button as follows <asp:Button ID="btnExport" Text="Export" runat="server" OnClientClick = "EnableExport()" OnClick="btnExport_Click" />

    Hope it helps. :)

    Tuesday, February 7, 2012 5:27 AM