Error when generating in Excel

I am currently having a problem in production when generating a report in
Excel. I get the following error:
Reporting Services Erro
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Excel Rendering Extension : Invalid index in the index path.
----
Microsoft Reporting Services
I would certainly appreciate if any one has a solution to this issue. One
thing I have found on the web is that they talk about Office version.(i.e. we
should have Office 2003 or XP on the reporting services machine & we do have
it in production) This report was working fine in production off recent
without any problems. But now I get this error on generating a report. The
other reports are working fine in terms of generating to excel.
Any inputs is greatly appreciated.
Thanks
MukundI got to view the log files in the Reporting Services directory & found the
following details. May be it will help to find the solution to this problem.
Please let me know if anyone has a solution to this issue.
Mukund
-----aspnet_wp!chunks!998!12/22/2004-15:01:24::
i INFO: ### GetReportChunk('RenderingInfo_EXCEL', Other), chunk was not
found! this=f881b8dc-4271-49a8-aed4-4b1a9f0d1620
aspnet_wp!reportrendering!998!12/22/2004-15:01: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.Exception: Excel Rendering Extension : Invalid index in
the index path.
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHiddenReportItems(IntList indexPath, PageReportItems& pageRI)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem
parentDataRegion, Boolean isPageNeedsEvaluation, Hashtable& riReferenceTable,
PageLayout& pageLayout, PageReportItems& pageRIItems, Stack&
dynamicLayoutStack, Hashtable& dataRegionsTable, Boolean[]& reduceRowGapList,
OutlineRenderStates[]& verticalOutlineStates, OutlineRenderStates[]&
horizontalOutlineStates)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderStaticPage(StreamWriter
streamWriter, ReportItem parentDataRegion, PageLayout pageLayout, Hashtable
formulaRIMap, Int32 currentPageNumber, PageReportItems& pageRIItems, Boolean&
isPageNeedsHeader, ExcelStyle& footerStyle, Stack& dynamicLayoutStack)
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 --
aspnet_wp!webserver!998!12/22/2004-15:01:27:: 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.Exception: Excel Rendering Extension : Invalid index in
the index path.
aspnet_wp!library!9bc!12/22/2004-15:11:13:: i INFO: Cleaned 0 batch records,
0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
-----
"Mukund" wrote:
> I am currently having a problem in production when generating a report in
> Excel. I get the following error:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Excel Rendering Extension : Invalid index in the index path.
> ----
> Microsoft Reporting Services
> I would certainly appreciate if any one has a solution to this issue. One
> thing I have found on the web is that they talk about Office version.(i.e. we
> should have Office 2003 or XP on the reporting services machine & we do have
> it in production) This report was working fine in production off recent
> without any problems. But now I get this error on generating a report. The
> other reports are working fine in terms of generating to excel.
> Any inputs is greatly appreciated.
> Thanks
> Mukund
>|||I am aslo getting the same error. Its works for other reports. Only one report i cant export to excel and html. if any one know the solution pls reply...
From http://www.developmentnow.com/g/115_2004_12_0_0_454135/Error-when-generating-in-Excel.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com