ReportRenderingException when exporting to excel

Hi all
I have a report that works fine for html and pdf rendering. But when I
export it to excel RS throws a ReportRenderingException. The error is "Stack
empty". Anything else like PDF, TIFF... is rendering without errors. Does
anyone has similar problems or knows whats wrong? Can this be a bug?
Here's an extraction of the log file:
w3wp!library!ed8!12/07/2004-17:03:20:: i INFO: Call to RenderNext(
'/Astrada/Ferienuebersicht' )
w3wp!chunks!ed8!12/07/2004-17:03:20:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=cdb86ab2-85ce-41b8-9edc-3faffec8410b
w3wp!reportrendering!ed8!12/07/2004-17:03:24:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.InvalidOperationException: Stack empty.
at System.Collections.Stack.Pop()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.GetPostFixNotation(String[] tokens, ArrayList finalExpr)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.ProcessFormula(String formula, ArrayList& postFixList, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateExcelFormula(IReportItemInfo
reportItemInfo, String outputTypeCode, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(ReportItemInfo
reportItemInfo, PageCell pageCell, PageTableGrid pageTableGrid, Hashtable&
duplicateItemsTable, Int32 row, Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!ed8!12/07/2004-17:03:30:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.InvalidOperationException: Stack empty.
Thanks for any help!
M. PeyerThis problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve|||This problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve