Post reply

Export Report to Excel 2000 Problem

  • August 4, 2008 at 9:42 am

    #210803

    Using SQL Server 2005 SP1 and Excel 2000.

    I have three reports with matrix controls. When I attempt to export the reports in Report Manager to Excel, I get a Windows dialog prompt to 'open' or 'save'. When I choose 'open', Excel opens, I get a brief flicker in Excel, but the report does not export to Excel. When I choose 'save', the report does save to Excel.

    I would like for the report to export when the user chooses 'open'. Anyone have an idea what the problem might be?

    Thanks.

  • August 6, 2008 at 1:39 pm

    #854099

    What I've just discovered is that when I close Excel after the export fails, and then export again to Excel (a second export), it works.

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

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