Microsoft Dynamics CRM 4.0 does not return the results if you try to export the results to an Excel worksheet after you use the Next X Days condition in the Advance Find query

Article translations Article translations
Article ID: 953999 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you filter the data of a view by using the Next X Days condition in the Advanced Find query in Microsoft Dynamics CRM 4.0, the correct results are displayed. However, if you try to export the results to a Microsoft Office Excel worksheet by using the Dynamic worksheet option, Microsoft Dynamics CRM 4.0 does not return the results in the Excel worksheet.

CAUSE

This problem occurs when the criteria in the Advanced Find query are converted from a FetchXml statement into an SQL query. The logic that converts the query passes two parameters in the incorrect order.

RESOLUTION

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about Microsoft Dynamics CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 953999 - Last Review: January 20, 2012 - Revision: 2.2
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Keywords: 
kbexpertiseinter kbmbsmigrate kbqfe kbhotfixserver kbautohotfix kbfix KB953999

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com