Export to Excel throwing an exception
Hi all I have a report that when I export to Excel gives an exception. Long shot but anyone make sense of the error report below. All other reports are working fine. TIA. Server Error in '/Reports' Application. -------------------------------------------------------------------------------- For more information about this error navigate to the report server on the local server machine, or enable remote errors Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors] [Exception: An error occurred during rendering of the report.] Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +503 Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958 Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84 Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +153 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
November 26th, 2010 6:30am

In the error message it recommends running the report again on the local machine. This means connecting to the server wehre SSRS is installed and then running the report - you should then get a different error message, normally in plain English, like Login failed for user X I would guess that as you are exporting to excel you have hit an excel file limitation - eihter the number of rows or the number of columns being returned - this does not fail very gracefully in SSRS. Seth http://lqqsql.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2010 11:33am

Thanks Seth I went down the old school route of deleting elements one by one and seeing if the report would export to Excel Narrowed it down to a single textbox in a group row. Deleted the expression and coded it from scratch and that fixed it. Go figure. :-) As an aside I am starting to seriously think SSRS is the poor relation of the stack......
November 26th, 2010 4:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics