I have made a cross matrix report with 1 column and row group having same column and rows name and displaying a value for each cross section in report.I need to color the cell with same color where row and column cross on same name anddiffrentcolor on above and below the cross digonal and keep the sorting in below manner only. ARREAR_CLASSIFICATION NOT CLASSIFIED LEG MAN DCI BRC WOD NOT CLASSIFIED 103333 7 12 0 0 0 LEG 0 2005 11 0 0 0 MAN 22 1 874 0 0 0 DCI 0 0 0 117 0 0 BRC 0 0 0 0 47 0 WOD 0 0 0 0 0 93

Hi SMISRA, Thanks for your question. According to your description, I understand that in the matrix, if the cell’s row’s name is same to the column’s name, you would like to set these cells’ font in the same color, and this color is different from the default color, right? If I misunderstand your question, please let me know. In order to achieve this requirement, I would suggest you using sum() function to sum the cell’s value in the two groups, then compare the two sum values, if the two values are equivalent, it means that the cell’s row’s name is same as the column’s name. Supposing that in the matrix, the Row Group’s name is Group1, Column Group’s name is Group2, the field name of the Data textbox is Results, 1. In the Design Surface of the report, right-click the textbox of the Results in your matrix, select Text box Properties. 2. In the Text box Properties dialog box, click Font in the left pane, click fx button on the right of drop-down list of Color. 3. In the Expression dialog box, type in like this, =Iif(Sum(Fields!Results.Value,"Group1")=Sum(Fields!Results.Value,"Group2"),"Red","Black"). Please click the Preview tab on the report, the font color is Red if the cell has the same row’s name and column’s name, however, the others’ font color is Black, just like below, If your issue still exists, please let me know. Thanks, Sharp Wang Best Regards. Sharp Wang

Hi SMISRA, Thanks for your question. According to your description, I understand that in the matrix, if the cell’s row’s name is same to the column’s name, you would like to set these cells’ font in the same color, and this color is different from the default color, right? If I misunderstand your question, please let me know. In order to achieve this requirement, I would suggest you using sum() function to sum the cell’s value in the two groups, then compare the two sum values, if the two values are equivalent, it means that the cell’s row’s name is same as the column’s name. Supposing that in the matrix, the Row Group’s name is Group1, Column Group’s name is Group2, the field name of the Data textbox is Results, 1. In the Design Surface of the report, right-click the textbox of the Results in your matrix, select Text box Properties. 2. In the Text box Properties dialog box, click Font in the left pane, click fx button on the right of drop-down list of Color. 3. In the Expression dialog box, type in like this, =Iif(Sum(Fields!Results.Value,"Group1")=Sum(Fields!Results.Value,"Group2"),"Red","Black"). Please click the Preview tab on the report, the font color is Red if the cell has the same row’s name and column’s name, however, the others’ font color is Black, just like below, If your issue still exists, please let me know. Thanks, Sharp Wang Best Regards. Sharp Wang