Error exporting to excel VendSRS aging report.

• pascariadrian

  Newbie

  Points: 9

  More actions

  January 17, 2011 at 2:55 am

  #230263

  The problem is with VendSRS aging report.

  The report is displayed fine, but exporting to excel is not working. The error is received:

  Exception: An internal error occurred on the report server. See the error log for more details.] Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +900 Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +1313 Microsoft.Reporting.WebForms.ServerModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String& mimeType, String& fileExtension) +209 Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +219 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +171 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +599 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

  What can be the solution for this issue?

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  January 17, 2011 at 3:09 am

  #1274159

  instead of exporting from sql, you can connect your excel to database directly by selecting correct provider and correct connection setting.

  Once your connection is authenticated, you can provide your query to fetch data from database.

  ----------
  Ashish