Microsoft CRM Exporting reports

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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
Kenneth_CanovaAuthor Commented:
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,
Not a problem man,
Glad to be of service
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.