I have a report that prints earnings statements for over 4,000 employees. Of those 4,000, 110 are aborting with the error:
The processing of Parent for the tablix 'table 1' cannot be performed. Cannot compare data types System.Int32 and System.String. Please check the data type returned by the parent. (rsComparisonTypeError).
When I run the report in Visual Studio 2008 for an employee that fails on the report server, it runs successfully. I've compared data for a successful employee and a failing employee and don't see anything different in the two.
Has anyone seen this or have any suggestions for tracking the error down?