Microsoft Knowledge Base Email Alertz

(925453) - Discusses that Report Update Rollup 1 for Microsoft Dynamics CRM 3.0 is available. The rollup resolves several problems in Microsoft Dynamics CRM 3.0.

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 925453 - Last Review: February 26, 2007 - Revision: 1.5

Report Update Rollup 1 for Microsoft Dynamics CRM 3.0 is available

Hotfix download is availableHotfix Download Available
View and request hotfix downloads

On This Page

INTRODUCTION

This article contains details about Report Update Rollup 1 for Microsoft Dynamics CRM 3.0. This article also describes the hotfixes and the updates that are included in Report Update Rollup 1 for Microsoft Dynamics CRM 3.0.

MORE INFORMATION

Build number of Report Update Rollup 1

The build number of Report Update Rollup 1 for Microsoft Dynamics CRM 3.0 is 3.0.5300.1301.

Comprehensive list of issues that are fixed in Report Update Rollup 1 for Dynamics Microsoft CRM 3.0

Report Update Rollup 1 for Microsoft Dynamics CRM 3.0 contains fixes for the issues that are described in the following Microsoft Knowledge Base articles:
  • 913084  (http://kbalertz.com/Feedback.aspx?kbNumber=913084/ ) The sales stage values are blank when you print the "Competitor Win Loss Detail" report in Microsoft Dynamics CRM 3.0
  • 913330  (http://kbalertz.com/Feedback.aspx?kbNumber=913330/ ) Reporting Services error message when the Service Activity report in Microsoft Dynamics CRM is grouped by week: "SET DATEFIRST 0 is out of range"
Repport Update Rollup 1 for Microsoft Dynamics CRM 3.0 also contains fixes for the following issues:
  • If you set the Created On Date parameter to Today to filter records in the "Account Summary" report, no record is returned.
  • The value in the %Overall Revenue field is incorrectly calculated in the "Lead Source Effectiveness" report. For example, you take the following actions:
    • You qualify a lead that contains a lead source to an opportunity.
    • You set estimated revenue for the opportunity to $1,000.00.
    • You close the opportunity by using the Status Reason value of Won.
    • You set actual revenue to $350.
    • You run the "Lead Source Effectiveness" report.
    In this example, the %Overall Revenue value is incorrectly calculated as 35 percent instead of as 100 percent.
  • The value in the Total service activity count field is incorrectly calculated in the "Service Activity Volume" report. For example, if you have a service activity that contains more than one assigned resource, the service activity is incorrectly counted two times in the Total service activity count field.
  • The "No Case Data" English string and the "No Account Data" English string are not available for localization in Microsoft Dynamics CRM 3.0 reports. If you run an account or a case report that does not contain data, the "No Case Data" string or the "No Account Data" string is returned. However, the strings are not available for localization.
  • If you sort data by clicking the grid header of a report on a localized version of Microsoft Dynamics CRM 3.0, you receive the following error message:
    The item 'organizational unit' report name cannot be found. (rsItemNotFound).
    The following reports are affected:
    • Top Knowledge Articles Detail
    • Neglected Lead Details
    • Neglected Case Details
  • If you group the "Service Activity Volume" report by users in the Turkish version of Microsoft Dynamics CRM 3.0, you receive the following error message:
    An error has occurred during report processing. (rsProcessingAborted) Get Online Help
    Query execution failed for data set 'DSSnapshotCount'. (rsErrorExecutingCommand) Get Online Help
    Invalid column name 'activityID'.
    Note In Turkish, "Servis Aktivitesi Hacmi" means "Service Activity Volume."
  • If you click a column header in the "Opportunity data" subreport of the "Lead Source Effectiveness" report, you receive the following error message:
    Default value or value provided for the report parameter 'CRM_leadsource' is not a valid value. (rsInvalidReportParameter) Get Online Help.
    For example, you receive this error message if you click the data in the %Overall Revenue field in the "Lead Source Effectiveness" report, and then you click a column header in the "Opportunity data" subreport.
  • If you click a column header in the "Competitor Win Loss" report in the Turkish version of Microsoft Dynamics CRM 3.0, you receive the following error message:
    The item '/Organizational Unit/Rakip Kazancı Kaybı' cannot be found. (rsItemNotFound) Get Online Help.
  • If you sort reports by clicking a column header in the subreport of the "Product by Contact" report in the localized versions of Microsoft Dynamics CRM 3.0, you receive the following error message:
    The item '/Organizational Unit/ReportName cannot be found. (rsItemNotFound) Get Online Help.
    For example, you receive this error message in the Turkish version of Microsoft Dynamics CRM 3.0 if you take the following actions:
    • You open the "Opportunity data" subreport of the "Product by Contact" report.
    • You click a column header in the "Opportunity data" subreport.
  • When you click a column header in a subreport of the "Product by Contact" report, you receive one of the following error messages:
    • The item '/Organizational Unit/Contact Product View Detail' cannot be found. (rsItemNotFound) Get Online Help.
    • An error has occurred during report processing. (resProcessingAborted) Get online Help.
      Invalid attempt to read when no data is present.
    For example, you receive this error message if you take the following actions:
    • You click Opportunities in the Display list in the "Product by Contact" report.
    • You click View Report.
    • You click Show All.
    • You click a column header in the "Products by Name: Opportunities" subreport.
  • If you click the %Overall Revenue column header in the "Lead Source Effectiveness" report in the Norwegian version of Microsoft Dynamics CRM 3.0, you receive the following error message:
    The item '/Organizational Unit/Effektivisering av kundeemnekilde' cannot be found. (rsItemNotFound) Get Online Help.
    Note In Norwegian, "Effektivitet for kundeemnekilde" means "Lead Source Effectiveness."
  • If you click a graph in the "Neglected Cases" report in the Portuguese version of Microsoft Dynamics CRM 3.0, you receive the following error message:
    An attempt was made to set a report parameter 'CRM_FilteredIncident' that is not defined in this report. (rsUnknownReportParameter) Get Online Help.
    Note In Portuguese, "Casos Negligenciados" means "Neglected Cases."
  • The "Not Specified" English string is not available for localization in the "Neglected Accounts" report.
  • If you try to print a report in Microsoft Dynamics CRM 3.0, you cannot print the report as expected. For example, the report cannot be printed. Or, the report is truncated on one page, and the report is then continued on another page. When this problem occurs, you are prompted to load 8.3-by-11-inch paper into the printer, and you receive the following error message:
    Held: Resources Needed.

Hotfix information

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 (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 rollup 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.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Account distribution detail.rdlNot Applicable109,23727-Sep-200623:28Not Applicable
Account distribution.rdlNot Applicable64,93027-Sep-200623:28Not Applicable
Account overview sub-report.rdlNot Applicable173,06327-Sep-200623:28Not Applicable
Account overview.rdlNot Applicable12,36027-Sep-200623:28Not Applicable
Account summary sub-report.rdlNot Applicable86,99127-Sep-200623:28Not Applicable
Account summary.rdlNot Applicable39,83027-Sep-200623:28Not Applicable
Campaign activity status detail.rdlNot Applicable25,54027-Sep-200623:28Not Applicable
Campaign activity status sub-report.rdlNot Applicable57,89227-Sep-200623:28Not Applicable
Campaign activity status.rdlNot Applicable11,94627-Sep-200623:28Not Applicable
Campaign comparison.rdlNot Applicable81,62127-Sep-200623:28Not Applicable
Campaign opportunity estimated revenue detail.rdlNot Applicable18,80527-Sep-200623:28Not Applicable
Campaign opportunity realized revenue detail.rdlNot Applicable18,49527-Sep-200623:28Not Applicable
Campaign performance sub-report.rdlNot Applicable146,50727-Sep-200623:28Not Applicable
Campaign performance.rdlNot Applicable11,99927-Sep-200623:28Not Applicable
Campaign placed order detail.rdlNot Applicable16,76927-Sep-200623:28Not Applicable
Campaign response detail.rdlNot Applicable24,43427-Sep-200623:28Not Applicable
Campaign task detail.rdlNot Applicable25,45327-Sep-200623:28Not Applicable
Case summary table detail.rdlNot Applicable60,95727-Sep-200623:28Not Applicable
Case summary table.rdlNot Applicable90,35227-Sep-200623:28Not Applicable
Competitor win loss details.rdlNot Applicable80,55927-Sep-200623:28Not Applicable
Competitor win loss.rdlNot Applicable50,23527-Sep-200623:28Not Applicable
Invoice status detail.rdlNot Applicable63,64427-Sep-200623:28Not Applicable
Invoice status.rdlNot Applicable31,99619-Sep-200623:15Not Applicable
Lead source effectiveness.rdlNot Applicable105,53627-Sep-200623:28Not Applicable
Neglected accounts detail.rdlNot Applicable89,15727-Sep-200623:28Not Applicable
Neglected accounts.rdlNot Applicable35,29427-Sep-200623:28Not Applicable
Neglected cases detail.rdlNot Applicable108,47227-Sep-200623:28Not Applicable
Neglected cases.rdlNot Applicable93,88527-Sep-200623:28Not Applicable
Neglected leads detail.rdlNot Applicable70,63427-Sep-200623:28Not Applicable
Neglected leads.rdlNot Applicable42,26027-Sep-200623:28Not Applicable
Products by account detail.rdlNot Applicable215,22127-Sep-200608:29Not Applicable
Products by account.rdlNot Applicable53,33027-Sep-200623:29Not Applicable
Products by contact detail.rdlNot Applicable219,51027-Sep-200623:29Not Applicable
Products by contact.rdlNot Applicable53,28427-Sep-200623:29Not Applicable
Sales history detail.rdlNot Applicable107,90327-Sep-200623:29Not Applicable
Sales history.rdlNot Applicable31,39127-Sep-200623:29Not Applicable
Sales pipeline detail.rdlNot Applicable92,00327-Sep-200623:29Not Applicable
Sales pipeline.rdlNot Applicable108,50627-Sep-200623:29Not Applicable
Service activity volume detail.rdlNot Applicable100,12327-Sep-200623:29Not Applicable
Service activity volume.rdlNot Applicable65,80627-Sep-200623:29Not Applicable
Top knowledge base articles detail.rdlNot Applicable90,34927-Sep-200623:29Not Applicable
Top knowledge base articles.rdlNot Applicable59,48827-Sep-200623:29Not Applicable
User summary.rdlNot Applicable28,27127-Sep-200623:29Not Applicable

Installation information

This rollup 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 of the C drive.
  2. Click Workplace, and then click Reports.
  3. In the Category list, click Reports.

    Note Some updated reports are hidden reports. Therefore, you must also click Hidden Reports in the Category list to update a hidden report.
  4. In the Entity list, click the entity for the report that you want to update. For example, to update the "Account Summary" report, click the Account entity.
  5. Click the report that you want to update, click More Actions, and then click Edit Report.
  6. In the Report: Report_Name dialog box, click File in the Report Type pane, and then click Browse.

    Note In this dialog box name, Report_Name represents the actual report name.
  7. Select the report that you copied in step 1, and then click Save and Close.
Note To revert to the original report file, repeat steps 2 through 7, but select the original .rdl file in step 7. 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 rollup.

Restart requirement

If you are prompted, restart the computer after you apply this rollup.

Removal information

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

Known issues

For more information about known issues, click the following article number to view the article in the Microsoft Knowledge Base:
927108  (http://kbalertz.com/Feedback.aspx?kbNumber=927108/ ) Error message when you try to install the Update Rollup 1 for the Microsoft CRM 3.0 client for Microsoft Office Outlook: "Setup could not find Microsoft CRM 3.0 Client for Microsoft Office Outlook"

APPLIES TO
  • Microsoft CRM 3.0
Keywords: 
kbautohotfix kbhotfixserver kbqfe kberrmsg kbmbsreports kbinfo kbmbsmigrate KB925453
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate