Report Errors for a view employees on Report Server, Not in VS2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Report Errors for a view employees on Report...

Report Errors for a view employees on Report Server, Not in VS2008

Rate Topic

Display Mode

Topic Options

Author

Message

lmarrette

Posted Friday, March 01, 2013 9:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:32 AM
Points: 4, Visits: 7

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?

Thanks,

Lee

Post #1425589

Daniel Bowlin

Posted Monday, March 04, 2013 7:28 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418

The 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\LogFiles

Post #1426242

« Prev Topic | Next Topic »

Permissions