Reports in Excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Reports in Excel

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
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) +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 Thanks. Najeed.

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>
Hi satya, Below are the details: Sql server 2005 sp1 -32 bit( sql server and reporting services) Win 2003 standard sp1 Thanks. Najeed.


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
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=618374&SiteID=1 This is what I have done to fix this excell issue. Hope this helps…please let me know if you find any other answer.
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.]
. Thanks. Najeed

Najeed,
You have to do that the Reporting services end. – Deepak V
Thanks Deepak, Got it. Najeed
]]>