SSRS 2008 Migration Issue in Report

Hariharan Krishnamoorthi

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hariharan Krishnamoorthi9y ago
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.
0
Rajkiran Swain9y ago
https://foxdeploy.com/2014/01/23/sccm-sql-error-has-occurred-during-report-processing/
0
Rajkiran Swain9y ago
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.
0