Report Rendering Problem
-
Hi all,
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 .
Thanks.
------------ --------- --------- --------- --------- --------- -
------------ ------
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.
-
Have you looked at the log files on the server Reporting Services is running on?
--------------------
Colt 45 - the original point and click interface
-
Hi Phill,
I looked at the sql server logs, but there is nothing regarding reporting services.
But , when i saw in windows event log , i found this:
Any idea Phill.
Thanks.
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 6/12/2007
Time: 1:24:45 PM
User: N/A
Computer: PMD_Server
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6/12/2007 1:24:45 PM
Event time (UTC): 6/12/2007 6:24:45 PM
Event ID: 4a896f367c404870a8d1e84bf6c9ebb8
Event sequence: 668
Event occurrence: 5
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-1-128260554700291338
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: D:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\
Machine name: PMD_Server
Process information:
Process ID: 4692
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: Exception
Exception message: For more information about this error navigate to the report server on the local server machine, or enable remote errors
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User: BCBSMN-DOM-01\a0f577
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace:
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply