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.
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.