I have developed a report in SSRS 2005. When I try to export the output to Excel, it shows an error saying:
Error occurred during local report processing.
Error occurred during rendering of the report. Stack Empty.
Do anyone have any idea what this means and how to fix it?
I can render the report in other formats (Adobe, csv etc) without any problem. My other reports, under same project and using same dataset, are working fine.
Thanks in Advance.
Have you checked your log files for errors?
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
You may need to crank up the level of tracing to get anything interesting:
http://technet.microsoft.com/en-us/library/ms156500.aspx
Does the report render in Excel for a different dataset? Try faking a dataset using something like:
SELECT 1 AS Age, 'M' AS Sex
UNION
SELECT 7 AS Age, 'F' AS Sex
and see if you render correctly. Make sure you have 'alligned your edges' to reduce the complexity of the resulting Excel. If you want to (are willing/able to) send me your RDL, I will take a look and post the results of my analysis back here.
