HI Experts Initially my report is in ssrs 2005 , it is the matrix report running fine now i migrated the report into ssrs 2008 i am getting the below error, and i found that where it is failing, i have three row level grouping, the parent group is on region and we selected the Recursive parent as month(reportdate) if i remove this recursive parent group the report is giving the data,but not proper and and we are missing some date why the report working fine in ssrs 2005 and not working in ssrs 2008 error: A error occured while processing the local reporting The processing of parent for the tablix1'Matrix'cannot be performed,the comparision failed.please check the data type returned by the parent

SSRS 2008 works a bit differently. Please see the solution provided on http://connect.microsoft.com Your report has a table with 2 table groups. Now based on the dataset, it seems this is just a regular nested grouping of data - however the inner table group has an explicitly defined parent group expression. The parent group expression is the same as the group expression of the outer table group. In RS 2005, this (probably unintentional and errorness) recursive grouping was ignored. However in RS 2008 that's not the case and the report fails with the following internal error message: The processing of Parent for the tablix ‘table1’ cannot be performed. Cannot compare data of types System.String and System.Int16. Please check the data type returned by the Parent. Note that it tries to compare a String and an Int16 - this happens because the inner table group expression groups on an Int16, but the there is an explicit recursive group hierarchy (parent expression) defined as string. The solution for the reports is to just remove all those recursive parent group expressions, because you really just want regular nested table groups, but not a recursive hierarchy. Again, if you just want nested groups, please do NOT specify a recursive parent group expression. Those should only be used if you really have recursive hierarchies in your data (e.g. parent-child hierarchy in a SSAS dataset). I attached both modified reports (compare them in Windiff with your original reports and you will see that I just removed all the parent group expressions). You might also want to check whether some of your other reports have a similar problem - a recursive parent is defined when you really just wanted regular nested table groups. Source: http://connect.microsoft.com/SQLServer/feedback/details/367275/the-processing-of-parent-for-the-tablix-table1-cannot-be-performed

SSRS 2008 works a bit differently. Please see the solution provided on http://connect.microsoft.com Your report has a table with 2 table groups. Now based on the dataset, it seems this is just a regular nested grouping of data - however the inner table group has an explicitly defined parent group expression. The parent group expression is the same as the group expression of the outer table group. In RS 2005, this (probably unintentional and errorness) recursive grouping was ignored. However in RS 2008 that's not the case and the report fails with the following internal error message: The processing of Parent for the tablix ‘table1’ cannot be performed. Cannot compare data of types System.String and System.Int16. Please check the data type returned by the Parent. Note that it tries to compare a String and an Int16 - this happens because the inner table group expression groups on an Int16, but the there is an explicit recursive group hierarchy (parent expression) defined as string. The solution for the reports is to just remove all those recursive parent group expressions, because you really just want regular nested table groups, but not a recursive hierarchy. Again, if you just want nested groups, please do NOT specify a recursive parent group expression. Those should only be used if you really have recursive hierarchies in your data (e.g. parent-child hierarchy in a SSAS dataset). I attached both modified reports (compare them in Windiff with your original reports and you will see that I just removed all the parent group expressions). You might also want to check whether some of your other reports have a similar problem - a recursive parent is defined when you really just wanted regular nested table groups. Source: http://connect.microsoft.com/SQLServer/feedback/details/367275/the-processing-of-parent-for-the-tablix-table1-cannot-be-performed