SQL Server Performance

Reports in Excel

Discussion in 'SQL Server 2005 Reporting Services' started by najeed_dba, Jun 12, 2007.

  1. najeed_dba New Member

    Hello all,
    Actally i posted this topic under Reporting Services section, but no reply there, so i m removed from there and posted here.

    Some of my reports in sql server can be exported to Excel ,but some
    reports are not exporting to excel format, but that report i can
    export to PDF format. I am getting the following error , when i am
    trying to export in EXCEL format:

    Any ideas..

    ------------ --------- --------- --------- --------- --------- -
    ------------ ------
    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

    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) +489
    Microsoft.Reporting .WebForms. ServerReport. InternalRender( Boolean
    isAbortable, String format, String deviceInfo, NameValueCollection
    urlAccessParameters , Stream reportStream, String& mimeType, String&
    fileNameExtension) +959
    Microsoft.Reporting .WebForms. ServerReportCont rolSource. RenderReport
    (String format, String deviceInfo, NameValueCollection
    additionalParams, String& mimeType, String& fileExtension) +84
    Microsoft.Reporting .WebForms. ExportOperation. PerformOperation
    (NameValueCollectio n urlQuery, HttpResponse response) +143
    Microsoft.Reporting .WebForms. HttpHandler. ProcessRequest( HttpContext
    context) +75
    System.Web.CallHand lerExecutionStep .System.Web. HttpApplication. IExecu
    tionStep.Execute( ) +154
    System.Web.HttpAppl ication.ExecuteS tep(IExecutionSt ep step, Boolean&
    completedSynchronou sly) +64

    ------------ --------- --------- --------- --------- --------- -
    Version Information: Microsoft .NET Framework Version:2.0. 50727.42;
    ASP.NET Version:2.0. 50727.210


  2. satya Moderator

    Confirm what is the service pack level on SQL, Reporting Services, Office components and operating system in thsi regard.<br /><br />(I will be moving the thread back there for a followup [<img src='/community/emoticons/emotion-1.gif' alt=':)' />])<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  3. najeed_dba New Member

    Hi satya,

    Below are the details:

    Sql server 2005 sp1 -32 bit( sql server and reporting services)

    Win 2003 standard sp1



  4. deepaksql New Member

    I had the similar issue with the excell while exporting. This is what I did.

    1.) Navigate to the ReportDB --> ConfigurationInfo table --> EnableRemoteErrors to TRUE.
    2.) If the main report has a subreport and exporting the same would give you problem because there is a limitation with SSRS while exporting subreports to Excell.
    3.) Check the Excell Page limit(65535). If your report has more than 65535 rows then that could be the problem. To fix this issue please follow this link

    This is what I have done to fix this excell issue. Hope this helps...please let me know if you find any other answer.
  5. najeed_dba New Member

    Hi Deepak,
    Actually, my table has around 20 million rows.

    So, it is not fitting in the excel sheet.

    I read the link , which u send me, thanks for that,and i set EnableRemoteErrors to TRUE but actually i m not deeply invovled with SSRS. So, can you kindly give the procedure to change the limit of rows from 65k to more in excel. I will really appreciate that.

    And do we have to do this in excel (or) in the report means this --- [Create an outer table group using this group expression: =Int((RowNumber(Nothing)-1)/65000). Set Page break at end on the group.]


  6. deepaksql New Member

    You have to do that the Reporting services end.

    - Deepak V
  7. najeed_dba New Member

    Thanks Deepak,

    Got it.


Share This Page