InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:40:08 GMT20http://www.sqlservercentral.com/Forums/Topic1425589-150-1.aspxThe next thing I would do is to look through the Reporting Services trace logs on the server to look for a specific error. \\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFilesMon, 04 Mar 2013 07:28:03 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1425589-150-1.aspxI have a report that prints earnings statements for over 4,000 employees. Of those 4,000, 110 are aborting with the error:[i] 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). [/i]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?Thanks,LeeFri, 01 Mar 2013 09:36:33 GMTlmarrette