RS2005: Export to Excel error: Destination array was not long enough. Check destIndex and length

All,

I am using Reporting Services 2005. One of my reports is getting the following error when I try to export to Excel. It will export to .CSV though.

"Destination array was not long enough. Check destIndex and length, and the array's lower bounds."

Any suggestions would be greatly appreciated. Please copy me at machelle.a.chandler@.intel.com.

Machelle

What is the length of the longest string in the cells that you are trying to export?

Here is another description of similar bug:

http://dev.devbiz.com/forums/thread/1500.aspx

Seems as though the description in their case is too long to export.

|||I have exactly the same problem you mentioned Machelle. I guess it is because there is a certain limit for the data amaount in an Excel cell. Not the Excel cell itself but the buffer related to it. Exporting occassionally works when there is no cell with large amount of data.

I could not find a solution though. Any suggestion is appreciated.

EKREM

RS2005: Export to Excel error: Destination array was not long enough. Check destIndex and length

All,

I am using Reporting Services 2005. One of my reports is getting the following error when I try to export to Excel. It will export to .CSV though.

"Destination array was not long enough. Check destIndex and length, and the array's lower bounds."

Any suggestions would be greatly appreciated. Please copy me at machelle.a.chandler@.intel.com.

Machelle

What is the length of the longest string in the cells that you are trying to export?

Here is another description of similar bug:

http://dev.devbiz.com/forums/thread/1500.aspx

Seems as though the description in their case is too long to export.

|||I have exactly the same problem you mentioned Machelle. I guess it is because there is a certain limit for the data amaount in an Excel cell. Not the Excel cell itself but the buffer related to it. Exporting occassionally works when there is no cell with large amount of data.

I could not find a solution though. Any suggestion is appreciated.

EKREM

RS2005: Export to Excel error: Destination array was not long enough. Check destIndex and le

All,

I am using Reporting Services 2005. One of my reports is getting the following error when I try to export to Excel. It will export to .CSV though.

"Destination array was not long enough. Check destIndex and length, and the array's lower bounds."

Any suggestions would be greatly appreciated. Please copy me at machelle.a.chandler@.intel.com.

Machelle

What is the length of the longest string in the cells that you are trying to export?

Here is another description of similar bug:

http://dev.devbiz.com/forums/thread/1500.aspx

Seems as though the description in their case is too long to export.

|||I have exactly the same problem you mentioned Machelle. I guess it is because there is a certain limit for the data amaount in an Excel cell. Not the Excel cell itself but the buffer related to it. Exporting occassionally works when there is no cell with large amount of data.

I could not find a solution though. Any suggestion is appreciated.

EKREM

RS2005 June CTP Reserved.ReportViewerWebControl.axd - what is it?

Running a simple report in Report Manager. Try to export to Web Archive and
it wants to download Reserved.ReportViewerWebControl.axd but I can't seem to
find any information about how to use this file. What is AXD - it's not
listed on the internet.Most likely this is happening because you don't have any application
registered for the .MHTML file extension on the machine where you are
exporting. You should still be able to export by just typing in a file name
with a .mhtml file extension.
This should be fixed in later RS 2005 builds.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
news:96E0FDED-02A1-49BA-AB1E-37DDAF4B84BA@.microsoft.com...
> Running a simple report in Report Manager. Try to export to Web Archive
> and
> it wants to download Reserved.ReportViewerWebControl.axd but I can't seem
> to
> find any information about how to use this file. What is AXD - it's not
> listed on the internet.|||Thanks for the reply. However I've tried this on 2 machines now both with
MHTML as a registered file type.
On the server (Win2003), MHTML is registered to iexplore. On my own dev PC
(Win XP) it's msohtmed. The symptoms remain the same on both.
I do have another issue with url access crashing (bug 564712370)
Exception type: InvalidConfigFileTypeException
Exception message: The type
Microsoft.ReportingServices.UI.WebControlConnection,
ReportingServicesWebUserInterface
Could these be related?
Chris
"Robert Bruckner [MSFT]" wrote:
> Most likely this is happening because you don't have any application
> registered for the .MHTML file extension on the machine where you are
> exporting. You should still be able to export by just typing in a file name
> with a .mhtml file extension.
> This should be fixed in later RS 2005 builds.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
> news:96E0FDED-02A1-49BA-AB1E-37DDAF4B84BA@.microsoft.com...
> > Running a simple report in Report Manager. Try to export to Web Archive
> > and
> > it wants to download Reserved.ReportViewerWebControl.axd but I can't seem
> > to
> > find any information about how to use this file. What is AXD - it's not
> > listed on the internet.
>
>

RS2000 Large report fails to export to Excel

I have large report (200 pages, landscape 14x8.5) that will not export to
Excel.
Last night we scheduled the report to email us the Excel rendered file. The
subscription page shows the following error.
Failure sending mail: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
We ran the report manually today and tried to export through the Report
Manager and it tries to download a file that is only 1.84K large. When we
click save we get an error.
Does anyone have any idea what I could do get this report to export to Excel?
I've inlcuded the trace log below detailing the why the it would not send
the mail.
ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
processing item 16f10910-40d4-4c9c-a06c-438872d94b26
ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
446540f1-2ad4-4422-9751-4a98f39d6277 executed at 5/4/2006 4:00:09 AM.
ReportingServicesService!schedule!14d4!5/4/2006-04:00:09:: Creating Time
based subscription notification for subscription:
f804f939-b2ae-48cc-b656-8396e511fbb2
ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
446540f1-2ad4-4422-9751-4a98f39d6277 execution completed at 5/4/2006 4:00:09
AM.
ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
finished processing item 16f10910-40d4-4c9c-a06c-438872d94b26
ReportingServicesService!dbpolling!1384!05/04/2006-04:00:09::
NotificationPolling processing item e493718d-bcfd-48fb-8420-908baa3f80c4
ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1384!05/04/2006-04:00:13:: i INFO: Call to
RenderFirst( '/PSP Reporting/Resource Management/ResM02 - Allocation Report
By Initiative' )
ReportingServicesService!runningjobs!13e0!5/4/2006-04:01:40:: i INFO:
Adding: 1 running jobs to the database
ReportingServicesService!library!15e4!5/4/2006-04:09:40:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 17.
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 18.
ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR: There
is no data for the field at position 19.
ReportingServicesService!reportrendering!1384!05/04/2006-04:10:52:: 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.ArgumentOutOfRangeException: Index was out of range.
Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32 row, Int32 col)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, 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.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1384!05/04/2006-04:10:52:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1384!05/04/2006-04:10:52:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
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.ArgumentOutOfRangeException: Index was out of range.
Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32 row, Int32 col)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, 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.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1384!05/04/2006-04:10:52::
Notification e493718d-bcfd-48fb-8420-908baa3f80c4 completed. Success: False,
Status: Failure sending mail: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Report Server Email, Report: ResM02 - Allocation
Report By Initiative, Attempt 0
ReportingServicesService!dbpolling!1384!05/04/2006-04:10:52::
NotificationPolling finished processing item
e493718d-bcfd-48fb-8420-908baa3f80c4200 pages? AFAIK, Excel can only have about 65000 rows maximum. That could
be the cause of the error, if the report have too many rows of data.
"SBishop" <SBishop@.discussions.microsoft.com> wrote in message
news:68982103-D197-48FF-A23F-D6CAA7527758@.microsoft.com...
>I have large report (200 pages, landscape 14x8.5) that will not export to
> Excel.
> Last night we scheduled the report to email us the Excel rendered file.
> The
> subscription page shows the following error.
> Failure sending mail: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> We ran the report manually today and tried to export through the Report
> Manager and it tries to download a file that is only 1.84K large. When we
> click save we get an error.
> Does anyone have any idea what I could do get this report to export to
> Excel?
> I've inlcuded the trace log below detailing the why the it would not send
> the mail.
> ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
> processing item 16f10910-40d4-4c9c-a06c-438872d94b26
> ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
> 446540f1-2ad4-4422-9751-4a98f39d6277 executed at 5/4/2006 4:00:09 AM.
> ReportingServicesService!schedule!14d4!5/4/2006-04:00:09:: Creating Time
> based subscription notification for subscription:
> f804f939-b2ae-48cc-b656-8396e511fbb2
> ReportingServicesService!library!14d4!5/4/2006-04:00:09:: Schedule
> 446540f1-2ad4-4422-9751-4a98f39d6277 execution completed at 5/4/2006
> 4:00:09
> AM.
> ReportingServicesService!dbpolling!14d4!5/4/2006-04:00:09:: EventPolling
> finished processing item 16f10910-40d4-4c9c-a06c-438872d94b26
> ReportingServicesService!dbpolling!1384!05/04/2006-04:00:09::
> NotificationPolling processing item e493718d-bcfd-48fb-8420-908baa3f80c4
> ReportingServicesService!dbpolling!1460!5/4/2006-04:00:09::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!library!1384!05/04/2006-04:00:13:: i INFO: Call
> to
> RenderFirst( '/PSP Reporting/Resource Management/ResM02 - Allocation
> Report
> By Initiative' )
> ReportingServicesService!runningjobs!13e0!5/4/2006-04:01:40:: i INFO:
> Adding: 1 running jobs to the database
> ReportingServicesService!library!15e4!5/4/2006-04:09:40:: i INFO: Cleaned
> 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 17.
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 18.
> ReportingServicesService!processing!1384!5/4/2006-04:10:22:: e ERROR:
> There
> is no data for the field at position 19.
> ReportingServicesService!reportrendering!1384!05/04/2006-04:10:52:: 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.ArgumentOutOfRangeException: Index was out of range.
> Must be non-negative and less than the size of the collection.
> Parameter name: index
> at System.Collections.ArrayList.get_Item(Int32 index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32
> row, Int32 col)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
> pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, 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.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> ReportingServicesService!library!1384!05/04/2006-04:10:52:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!emailextension!1384!05/04/2006-04:10:52:: Error
> sending email.
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> 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.ArgumentOutOfRangeException: Index was out of range.
> Must be non-negative and less than the size of the collection.
> Parameter name: index
> at System.Collections.ArrayList.get_Item(Int32 index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.PageTableGrid.get_Item(Int32
> row, Int32 col)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(PageTableGrid
> pageTableGrid, ReportItemInfo reportItemInfo, PageCell pageCell, 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.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
> ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
> message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
> notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> ReportingServicesService!notification!1384!05/04/2006-04:10:52::
> Notification e493718d-bcfd-48fb-8420-908baa3f80c4 completed. Success:
> False,
> Status: Failure sending mail: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., DeliveryExtension: Report Server Email, Report: ResM02 -
> Allocation
> Report By Initiative, Attempt 0
> ReportingServicesService!dbpolling!1384!05/04/2006-04:10:52::
> NotificationPolling finished processing item
> e493718d-bcfd-48fb-8420-908baa3f80c4
>

rs exporting to excel problems

Good day,

I have a report designed in VS2005 deployed. The report opens fine through reporting services but when i try to export it to Excel format the numbers are being stored as text. I need the numbers to be exported in number format. How do I achieve this? Thanks

Hello,

You can use Format Property of that textbox(Set it to any Number format).

RS Custom Toolbar

Hi
We are developing a custom toolbar with the export, zoom,find and
previous/next page browsing functionalities. How can we go about developing
the page browsing functionality?
ThanksCreate
MyQueryDesigner : Microsoft.ReportDesigner.Interfaces.IQueryDesigner
where
public Control ToolBar
from IQueryDesigner
"Priya" <Priya@.discussions.microsoft.com> wrote in message
news:123D3CC1-2ED9-4BF2-A742-E7D1FA3470DB@.microsoft.com...
> Hi
> We are developing a custom toolbar with the export, zoom,find and
> previous/next page browsing functionalities. How can we go about
developing
> the page browsing functionality?
> Thanks

RS 2005, VS 2005 and specifying printer trays

I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services:

1. Export report as .pdf to file location. - Done

2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done

3. Set certain reports to print from certain trays on a specific printer. More specifically, for a certain report, I need the first page to print from Tray 1 and all remaining pages to print from Tray 2.

This is the task I am having problems with. I am trying to just get the tray selection working now with just a windows app but even if I get that far, will I need to extend RS and write my own print routine? Also, if this report is served to the client via URL, will I be able to specify the printer and tray or will I need a print server to handle this?

Thanks.

I have had luck with using ABCPDF for PDF manipulation.

http://www.websupergoo.com/

You could create two separate printers with different default trays and then print the first page to one printer, and the rest to another.

Bryan has a good article on printing from Reporting Services:
http://blogs.msdn.com/bryanke/articles/71491.aspx|||Unfortunately, this solution does not work for me. I am printing Optical Recognition Marks on the pages as they are printed so they need to come off the same printer so they are in the proper order to go into the feeder.

RS 2005, VS 2005 and specifying printer trays

I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services:

1. Export report as .pdf to file location. - Done

2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done

3. Set certain reports to print from certain trays on a specific printer. More specifically, for a certain report, I need the first page to print from Tray 1 and all remaining pages to print from Tray 2.

This is the task I am having problems with. I am trying to just get the tray selection working now with just a windows app but even if I get that far, will I need to extend RS and write my own print routine? Also, if this report is served to the client via URL, will I be able to specify the printer and tray or will I need a print server to handle this?

Thanks.

I have had luck with using ABCPDF for PDF manipulation.

http://www.websupergoo.com/

You could create two separate printers with different default trays and then print the first page to one printer, and the rest to another.

Bryan has a good article on printing from Reporting Services:
http://blogs.msdn.com/bryanke/articles/71491.aspx|||Unfortunately, this solution does not work for me. I am printing Optical Recognition Marks on the pages as they are printed so they need to come off the same printer so they are in the proper order to go into the feeder.