The Competitor Win Loss report contains incorrect data in Microsoft Dynamics CRM 3.0

Article translations Article translations
Article ID: 929306 - View products that this article applies to.
The hotfix that is discussed in this article is not available for the Chinese version of Microsoft Dynamics CRM or for the Japanese version of Microsoft Dynamics CRM.
Expand all | Collapse all

On This Page

SYMPTOMS

When you run the Competitor Win Loss report in Microsoft Dynamics CRM 3.0, the report contains incorrect data in the No. Open Opportunities Against Competitor field and in the No. Closed Opportunities Against Competitor field. The report lists some competitors that should not appear in the report.

RESOLUTION

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

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 item in Control Panel.

Microsoft Dynamics CRM 3.0 server

Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Account distribution detail.rdlNot applicable109,23706-Dec-200608:16Not applicable
Account distribution.rdlNot applicable64,93007-Dec-200600:16Not applicable
Account summary sub-report.rdlNot applicable90,87407-Dec-200600:16Not applicable
Competitor win loss details.rdlNot applicable80,35507-Dec-200600:16Not applicable
Competitor win loss.rdlNot applicable50,35607-Dec-200600:16Not applicable
Crmmsg.dll1.2.3297.12316,08826-May-200610:18x86
Crmnativeinteropproxy.dll3.0.5300.15163,409,72806-Dec-200612:33x86
Crmobjectmodel.dll3.0.5300.15166,751,53607-Dec-200604:32x86
Invoice status detail.rdlNot applicable63,64407-Dec-200600:16Not applicable
Invoice status.rdlNot applicable31,99631-Oct-200600:16Not applicable
Lead source effectiveness.rdlNot applicable105,53607-Dec-200600:16Not applicable
Microsoft.crm.application.components.platform.dll3.0.5300.1516367,48007-Dec-200604:15x86
Microsoft.crm.objectmodel.dll3.0.5300.1516318,28007-Dec-200604:21x86
Microsoft.crm.platform.server.dll3.0.5300.1516244,56007-Dec-200604:18x86
Microsoft.crm.scheduling.dll3.0.5300.1516305,99207-Dec-200604:20x86
Microsoft.crm.webservices.dll3.0.5300.1516453,44807-Dec-200604:16x86
Mscrmcustom.dll3.0.5300.1331172,33602-Nov-200618:22x86
Msvcr71.dll7.10.3052.4355,03226-May-200610:18x86
Neglected cases detail.rdlNot applicable108,47207-Dec-200600:16Not applicable
Neglected leads detail.rdlNot applicable70,63407-Dec-200600:16Not applicable
Neglected leads.rdlNot applicable42,26007-Dec-200600:16Not applicable
Pkgutil.cmdNot applicable11324-Aug-200612:09Not applicable
Pkgutil.exe1.2.3297.10188,79226-May-200610:18x86
Sales pipeline detail.rdlNot applicable92,00307-Dec-200600:16Not applicable
Sales pipeline.rdlNot applicable108,50607-Dec-200600:16Not applicable
Service activity volume detail.rdlNot applicable100,12307-Dec-200600:16Not applicable
Service activity volume.rdlNot applicable65,80607-Dec-200600:16Not applicable
Top knowledge base articles detail.rdlNot applicable90,34907-Dec-200600:16Not applicable
Top knowledge base articles.rdlNot applicable59,48808-Nov-200600:41Not applicable
Microsoft.crm.objectmodel.dll3.0.5300.1318,21617-Nov-200504:39x86
Microsoft.crm.platform.server.dll3.0.5300.1244,48817-Nov-200504:39x86
Microsoft.crm.scheduling.dll3.0.5300.1305,92817-Nov-200504:39x86
Crmdbhotfix.dll3.0.5300.1331103,72802-Nov-200618:21x86
Crmhotfix.cdfNot applicable14,13908-Dec-200611:17Not applicable
Kb911321_client.dll3.0.5300.151658,16807-Dec-200604:31x86
Kb911322_client.dll3.0.5300.151656,12007-Dec-200604:31x86
Kb913954_client.dll3.0.5300.151693,49607-Dec-200604:32x86
Kb914644_client.dll3.0.5300.151686,84007-Dec-200604:32x86
Kb914799_client.dll3.0.5300.151659,70407-Dec-200604:31x86
Kb915024_client.dll3.0.5300.151673,01607-Dec-200604:31x86
Kb915722_client.dll3.0.5300.1516103,73607-Dec-200604:32x86
Kb915799_client.dll3.0.5300.151661,24007-Dec-200604:31x86
Kb916629_client.dll3.0.5300.151672,50407-Dec-200604:31x86
Kb917098_client.dll3.0.5300.151689,91206-Dec-200612:32x86
Kb917109_client.dll3.0.5300.151658,68007-Dec-200604:31x86
Kb917536_client.dll3.0.5300.151681,20807-Dec-200604:32x86
Kb919008_client.dll3.0.5300.151687,86407-Dec-200604:32x86
Kb919429_client.dll3.0.5300.151660,21607-Dec-200604:31x86
Kb922807_client.dll3.0.5300.151662,77606-Dec-200612:31x86
Kb923057_client.dll3.0.5300.151675,57607-Dec-200604:31x86
Kb923074_client.dll3.0.5300.151659,70407-Dec-200604:31x86
Kb924105_client.dll3.0.5300.151688,37607-Dec-200604:32x86
Kb924371_client.dll3.0.5300.151689,40007-Dec-200604:32x86
Kb925163_client.dll3.0.5300.151666,36007-Dec-200604:31x86
Kb925473_client.dll3.0.5300.151666,87207-Dec-200604:31x86
Mscrmcustom.dll3.0.5300.1331172,33602-Nov-200618:22x86

Microsoft Dynamics CRM 3.0 client for Microsoft Office Outlook

Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Crmaddin.dll3.0.5300.15161,180,45606-Dec-200612:33x86
Crmmsg.dll1.2.3297.12316,08826-May-200610:18x86
Crmnativeinteropproxy.dll3.0.5300.15163,409,72807-Dec-200604:33x86
Crmobjectmodel.dll3.0.5300.15166,751,53607-Dec-200604:32x86
Microsoft.crm.application.components.platform.dll3.0.5300.1516408,44007-Dec-200604:15x86
Microsoft.crm.objectmodel.dll3.0.5300.1516318,28007-Dec-200604:21x86
Microsoft.crm.platform.server.dll3.0.5300.1516244,56007-Dec-200604:18x86
Mscrmcustom.dll3.0.5300.1331172,33602-Nov-200618:22x86
Msvcr71.dll7.10.3052.4355,03226-May-200610:18x86
Pkgutil.cmdNot applicable11324-Aug-200612:09Not applicable
Pkgutil.exe1.2.3297.10188,79226-May-200610:18x86
Syncqueue.dll3.0.5300.1516393,51207-Dec-200604:32x86
Microsoft.crm.objectmodel.dll3.0.5300.1318,23217-Nov-200504:42x86
Microsoft.crm.platform.server.dll3.0.5300.1244,50417-Nov-200504:42x86
Crmhotfix.cdfNot applicable3,72308-Dec-200611:16Not applicable
Mscrmcustom.dll3.0.5300.1331172,33602-Nov-200618:22x86

Installation information

This hotfix contains a self-extracting package file. After you extract the contents of the package file, follow these steps to install the updated reports on the Microsoft Dynamics CRM Web client:
  1. Copy the .rdl report files to the root directory on drive C.
  2. Click Workplace, and then click Reports.
  3. Update the Competitor Win Loss report. To do this, follow these steps:
    1. In the Category list, click All Reports.
    2. In the Entity list, click Competitors.
    3. Click the Competitor Win Loss report, click More Actions, and then click Edit Report.
    4. In the Report Type pane, click File, and then click Browse.
    5. Click the Competitor Win Loss.rdl report file that you copied in step 1, and then click Save and Close.
  4. Update the Competitor Win Loss Detail report. To do this, follow these steps:
    1. In the Category list, click Hidden Reports.
    2. In the Entity list, click Competitors.
    3. Click the Competitor Win Loss Detail report, click More Actions, and then click Edit Report.
    4. In the Report Type pane, click File, and then click Browse.
    5. Click the Competitor Win Loss Details.rdl report file that you copied in step 1, and then click Save and Close.
    Note To revert to the original report file, repeat steps 3 and 4. But, in steps 3e and 4e, select the original .rdl file. By default, the original .rdl file is in the following directory:
    C:\Program Files\Microsoft CRM\Reports\MSCRM

Prerequisites

You must have Microsoft Dynamics CRM 3.0 installed to apply this hotfix.

Restart requirement

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

Removal information

To remove this hotfix, follow the steps in the "Installation information" section to reinstall the original reports.

MORE INFORMATION

Steps to reproduce the problem

  1. Create an opportunity.
  2. Associate the opportunity with the following competitors:
    • Competitor 1
    • Competitor 2
    • Competitor 3
  3. Close the opportunity by using the following settings:
    • Status: Lost
    • Competitor: Competitor 3
  4. Run the Competitor Win Loss report.
The report incorrectly lists the following competitors:
  • Competitor 1
  • Competitor 2
The No. Closed Opportunities Against Competitor field contains a nonzero value for Competitor 1 and for Competitor 2. The No. Open Opportunities Against Competitor field contains a value of 0 (zero) for Competitor 1 and for Competitor 2. However, you expect the report to list only Competitor 3.

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

Properties

Article ID: 929306 - Last Review: April 4, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft CRM 3.0
Keywords: 
kbautohotfix kbmbsreports kbhotfixserver kbqfe kbmbsmigrate KB929306

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