Consider the following scenario in Microsoft Dynamics CRM 4.0. You use the Report Wizard to create a report that contains a chart. The chart uses a picklist as an axis. Then, you open the report. Next, you click a section of the chart to view some data tables. In this scenario, you receive the following error message in the report viewer:
An error has occurred during report processing. The processing of FilterExpression for table 'Table0' cannot be performed. Cannot compare data types of System.Int32 and System.String. Please check the data type returned by the FilterExpression.
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:
Microsoft Dynamics CRM 4.0 updates and hotfixes
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
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:
Microsoft Business Solutions CRM software hotfix and update package naming standards