Microsoft CRM Exporting reports

Posted on 2004-11-18
Last Modified: 2013-11-24
We have run across a situation where we are no long able to export reports to MS Word or MS Excel. In contact with MS CRM tech support and they to reload CRM, That is totally an unacceptable answer. We are using crystal reports to pull the info from the SQL DB.

Is there way to fix this issue without having to reload?

We get the following error msg:

 Server Error in '/' Application.

Request timed out.
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.Web.HttpException: Request timed out.

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:

[HttpException (0x80004005): Request timed out.]


Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET Version:1.0.3705.288

Any suggestions?

Question by:Kenneth_Canova
    LVL 6

    Expert Comment

    The error happens because of a timeout with the IIS server, I'll have to look and see what needs to be edited, but I am pretty positive it is in the web.config on the CRM server, bear with me for a few minutes and I will get you what you need. This is a very common CRM error in 1.0 and 1.2
    LVL 6

    Accepted Solution

    Here we go:


    This behavior may occur if there is a built-in limit on the PageServer service that permits it to process no more than 20,000 records. If the server processes this many records, the Crystal Enterprise PageServer service may stop, and you may receive one of the error messages that are described in this article.

    The "Server Error in '/' Application" error message may appear if you pull more data into a report than Microsoft CRM can process in the default ASP.NET timeout value of 90 seconds.


    To resolve this behavior, use these methods in the order they are presented until your issue is resolved.

    Method 1: Reconfigure the Crystal Enterprise PageServer Service

    If you receive the Crystal PageServer errors that are described in this article, reconfigure the Crystal Enterprise PageServer. To do so, follow these steps:

    1.  Open the Crystal Configuration Manager. To do so, click Start, point to Programs, point to Crystal Enterprise and then click Crystal Configuration Manager.

    2.  Stop Crystal PageServer. To do so, click Start, point to Administrative Tools, click Services, right-click Crystal Page Server and then click Stop.

    3.  Right-click Crystal Page Server, click Properties and then confirm that the Path to Executable box contains the following line:

    -maxDBResultRecords 0

    4.  If -maxDBResultRecords 0 does not appear in the Path to Executable box, at the end of the text, type:

    -maxDBResultRecords 0

    5.  Restart the PageServer.

    Method 2: Install the Microsoft CRM 1.0 Reporting Engine Hotfix

    If you receive the "Server Error in '/' Application" error message that is described in this article, install the Microsoft CRM 1.0 Reporting Engine Hotfix.

    Installation Information

    To obtain this hotfix, visit the following Microsoft Web site:

    Install this hotfix on the Microsoft CRM server. Make sure that the Microsoft Business Solutions CRM Deployment Manager is closed before you install this hotfix. This hotfix supports the following Setup switches:

    -  /?: Display the list of installation switches.
    -  /u: Use Unattended mode.
    -  /f: Force other programs to quit when the computer shuts down.
    -  /z: Do not restart when the installation is complete.
    -  /q: Use Quiet mode (no user interaction).
    -  /x: Extract the files without running Setup.

    For example, to install the hotfix without any user intervention, use the following command line:

    CRM1.0-KB829886-Server-Windows2000.exe /u /q

    To make sure that the hotfix is installed on your computer, confirm that the following registry key exists:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Microsoft CRM\1.0\Server\SP0\KB829886

    Removal Information

    You cannot remove this hotfix.

    Restart Requirement

    You do not have to restart your computer after you install this hotfix.

    File Information

    The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

    Date         Time   Version     Size     File name
    07-Nov-2003  17:04  1.0.3017.1  178,736  CRMQueryRecordset.dll
    06-Nov-2003  10:36    467,044  Crmscrmbridge.dll
    06-Nov-2003  10:38    290,819  Crmscrmconnector.dll
    06-Nov-2003  10:46     90,219  Crmscrmstatus_res_en.dll
    14-Oct-2003  11:27  1.0.3017.2   39,512  Microsoft.CRM.Pages.Reports.dll
    06-Nov-2003  10:38     36,666  P2smscrm.dll
    24-Oct-2003  15:50   684,089  Exlate85.dll

    Method 3: Install the Microsoft CRM 1.0 Reports Hotfix

    If you still receive the "Server Error in '/' Application" error message after you install the reports hotfix KB829886 that is described in Method 2, install the Microsoft CRM 1.0 Reports Hotfix KB829888 (a set of rewritten reports). To obtain this hotfix, visit the following Microsoft Web site:

    Note If you have customized reports by the same name, back up your customized reports, replace them with the reports that are included with hotfix 829888 and then re-apply your customizations to the new reports as required.

    Method 4: Customize the Default Microsoft CRM 1.0 Reports to Limit the Record Set Received

    If you still receive the "Server Error in '/' Application" error message after you install the Reporting Engine Hotfix KB829886 that is described in Method 2 in this article, customize the default Microsoft CRM 1.0 reports to limit the retrieved record set.

    When you run reports that have very large datasets, data retrieval can be slow. Retrieval speed depends on dataset size and hardware and network configuration. If the speed of the data retrieval results in a timeout, you may want to customize your reports to access a smaller dataset. This action decreases the retrieval time and avoids the timeout.

    To reduce the number of records, add a "Record Selection Formula" to the report. The following example discusses the "Account List By Territory" report. This report lists all the Accounts by Territory. Use a record selection formula to break this report into each Territory.

    For example, if you have four Territories: Northern, Southern, Eastern, and Western, create four reports from the existing "Account List By Territory" report. Limit each new report to the four Territories. To do so, edit the report in Crystal Reports Designer:

    1.  Turn off the Grouptree option.

    2.  Add a record selection formula that is similar to the following record selection formula to the report:


    3.  Save the report as "Account List By Northern Territory" or other name.

    Method 5: Extend the Timeout Value

    If you still have timeout issues, extend the timeout value. By default, the timeout value is 90 seconds. If you experience timeouts because of the number of records that are retrieved after you install the Reporting Engine Hotfix, install the Enhanced Reports, and limit the record sets that the reports retrieve, incrementally increase the reporting engine's timeout value. To do so, specify that timeout value in a Web.config file in the Inetpub\Wwwroot\Reports folder. (See the procedure below to create the Web.config file).This Web.config file increases the timeout value for the reporting engine to 10 minutes (600 seconds) without affecting the timeout values for the CRM Web application or other .NET applications that run on the server that hosts Microsoft CRM.

    To create a Web.config file in the Inetpub\Wwwroot\Reports folder, follow these steps:

    Create a Web.config file

    1.  Click Start, click Run and then in the Open box, type:

    notepad C:\inetpub\wwwroot\Reports\web.config

    2.  Click OK and then click Yes.
    3.  Copy and paste the following lines:

    <?xml version="1.0" encoding="utf-8"?>
    <httpRuntime executionTimeout="600"/>

    4.  On the File menu, click Save and then click Exit.
    LVL 6

    Expert Comment

    I recommend using Methods #1, and especially Method #5
    Ive done all methods I believe, but 1 and 5 should take care of your problem.

    Author Comment

    All five methods were helpful, but as you sugested methods 1 and 5 healed our problem. I wish I could double the points.

    Thanks Much,
    LVL 6

    Expert Comment

    Not a problem man,
    Glad to be of service

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now