SSRS 2008 Migration Issue in Report

Question

Dear all We are working on Migration process for SSRS 2005 to SSRS 2008. We have done this work and reports are working fine with ssrs 2008. But fiew of reports got the below error. Could you please help me on this. An error occurred during client rendering. An error has occurred during report processing. The processing of Parent for the tablix ‘tblXyzabc’ cannot be performed. The comparison failed. Please check the data type returned by the Parent. Thanks in advance.

Hariharan Krishnamoorthi · Answer

Hi All Still i am facing the same issue If the data returns minimum 200 records the report is generating. Incase it has more then 300 or 400 records the above error is displaying in the report. Please advise me on this. Thanks in Advance.

Rajkiran Swain · Answer

https://foxdeploy.com/2014/01/23/sccm-sql-error-has-occurred-during-report-processing/

Rajkiran Swain · Answer

Generally the error is received if the user doesn't have the sufficient permission to access the data source. The root cause can be that the users that fail to view the report have corresponding logins in the SQL Server Database Engine and have the access to the target database. To check whether it is the case or not you can also simply set the data source of the report to use a stored credentials from the report manager. If all the users can view the report proeprly after configuring the data source to use stored credentials it is the case we need to create the corresonding logins for the users and grant minimal permissions to perform the read-only operations on the databases.