A application error occurred on the server the current custom error settings for this application prevent
Thursday, December 09, 2010 7:49 PM
Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off". <!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="Off"/> </system.web> </configuration> Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL. <!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web> </configuration>
I'm getting below error when I export to Excel but export to CSV files is working fine, I'm using SSRS 2008 R2 Report Server, here is the error:-
Thursday, December 09, 2010 11:53 PM
I found that our Report Server 2008 R2 doesn't have any MS Office installated and so by default it is opening 2003 MS Office when I'm trying to export to Excel or to CSV, but record set I was pulling had more than 65K records so I think this is why I got above error message.
Now my question is if we install MS Office 2007 on our Report Server 2008 R2, does this resolve the issue?
Please let me know your feedback.
Monday, December 13, 2010 6:04 AMModerator
Below is words from a SQL Server Reporting Services(SSRS) blog, which will help you to understand the issue:
As of SQL Server 2008 R2, our Word and Excel renderers still generate Office 97-2003’s native file format, Binary Interchange File Format (BIFF8) (*.doc, *.xls). Office 2007 introduced the Open XML file formats (*.docx, *.xlsx) and we’ve received several suggestions through Microsoft Connect and other customer feedback to provide rendering extensions for these newer file formats.
We’ve heard your feedback and we’re actively working on new Open XML rendering extensions for Word and Excel and planning to ship them in SQL Server “Denali.”
Currently, we can use "page break" to break the report into mulitple pages, each page will be exported to one Work Sheet in Excel, we can force the page to contain less than 65536 rows to avoid the limitation in Excel 2003.
For more information about this workaround, please see:
For more information about the enhancement will be done in Denali, please see:
If you have any more questions, please feel free to ask.
Jin Chen - MSFT
- Marked As Answer by _Kumar Monday, December 13, 2010 10:05 PM
Monday, December 13, 2010 10:05 PM