Microsoft KB Archive/907722

= When you run a custom report in Microsoft CRM 1.2 from a URL that contains date parameters, the report returns incorrect data =

Article ID: 907722

Article Last Modified on 2/14/2007

-

APPLIES TO


 * Microsoft CRM 1.2

-





SYMPTOMS
Consider the following scenario:
 * You run a custom report in Microsoft CRM 1.2.
 * You specify the date parameters in a URL.

In this scenario, the report returns incorrect data. The data that is returned is not specific to the dates that you specify as parameters in the URL.



CAUSE
This issue may occur when the following conditions are true:  The report has been added to Microsoft CRM 1.2 by using Report Manager. The report contains parameterized fields that have the correct field type.

For example, the report contains a date field for which you use the Date format. You do not use the DateTime format for this field. The URL that calls the report contains the date in the following form:

Date(yyyy, mm, dd)





Hotfix information
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem.

To resolve this problem immediately, contact Microsoft Business Solutions Technical Support to obtain the hotfix. You can log on to the Microsoft Business Solutions Support site and create a new support request. To do this, visit the following Microsoft Web site:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact Microsoft Business Solutions Technical Support by telephone at (888) 477-7877.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Business Solutions Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Installation information
Install this hotfix on computers that are running Microsoft CRM 1.2 server.

Prerequisites
No prerequisites are required to install this hotfix.

Removal information
To remove this hotfix from a computer that is running Microsoft Windows Server 2003, Microsoft Windows XP, or Microsoft Windows 2000, use Add or Remove Programs in Control Panel.

System administrators may use the Spunist.exe utility to remove this hotfix from a computer that is running Windows Server 2003, Windows XP, or Windows 2000. The Spuninst.exe utility is located in the following folder:

%windir%\$NTUninstallKB907722$\Spuninst

For more information about how to use a package installer to remove a hotfix, click the following article number to view the article in the Microsoft Knowledge Base:

832475 Description of the new features in the package installer for Windows software updates

Note To remove this hotfix on computers that are running Windows XP with Service Pack 2 (SP2), you may have to turn on the Show updates filter feature. By default, the Show updates filter feature is turned off in Windows XP with SP2. For more information about how to turn on and to turn off the Show updates filter feature, click the following article number to view the article in the Microsoft Knowledge Base:

884786 How to manage the Currently installed programs list in Windows XP Service Pack 2 and in Windows XP Tablet PC Edition 2005

Restart requirement
If you are prompted, restart the computer after you install the hotfix.

File information
The English version of this hotfix has the file attributes (or later file attributes) 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.



MORE INFORMATION
For more information about how to run Microsoft CRM 1.2 reports from a URL, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/ms913881.aspx

For more information about how to add, delete, and rename Microsoft CRM 1.2 reports, click the following article number to view the article in the Microsoft Knowledge Base:

834791 Adding, deleting, and renaming Microsoft CRM Reports by using Microsoft CRM 1.2 Report Manager

To download a list of frequently asked questions about Microsoft CRM 1.2 reports, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=81886de8-a10a-473f-8125-49291e0f03d9

For more information about how to use Crystal Reports 9 to write parameter-driven reports for Microsoft CRM 1.2, click the following article number to view the article in the Microsoft Knowledge Base:

834790 How to use Crystal Reports 9 to write parameter-driven reports for Microsoft CRM 1.2

For more information about how to print parameter-driven reports in Microsoft CRM 1.2, click the following article number to view the article in the Microsoft Knowledge Base:

834913 You are prompted for parameters two times when you try to print a parameter-driven report in Microsoft CRM 1.2

For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Keywords: kbmbsreports kbmbsmigrate kbpubtypekc kbqfe kbhotfixserver KB907722

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.