Thanks for the suggestion. To be honest my example was derived from a pivot and the columns are dates. I decided to solve the problem using Hide Duplicates and some cell colouring that makes it easier to distinguish between plain empty cells and hidden empty cells.

Hi, According to the structure of your table, I notice that you have seven static columns, so I recommend you use Table control. In order to accomplish your requirements, we can refer to the following steps: Step one: Change your query as follows: SELECT C1, CASE WHEN C1=C2 THEN '' ELSE C2 END AS C2, CASE WHEN C2=C3 THEN '' ELSE C3 END AS C3, CASE WHEN C3=C4 THEN '' ELSE C4 END AS C4, CASE WHEN C4=C5 THEN '' ELSE C5 END AS C5, CASE WHEN C5=C6 THEN '' ELSE C6 END AS C6, CASE WHEN C6=C7 THEN '' ELSE C7 END AS C7 FROM MergeA Step two: Set an expression to column (C2, C3, C4, C5, C6, C7)’s left border color as follows: =IIF(Fields!Cn.Value="","White","DimGray") Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi I am using Report Builder 2.0 with Sql Server 2008. I would like to merge the column cells in a matrix/table when adjacent cells contain duplicates. The functionality I would like is similar to using the Hide Duplicates parameter but with the addition that the cells are also merged, i.e. have no borders when merged. Here is a before and after diagram: - c1 c2 c3 c4 c5 c6 c7 r1| A | B | B | B | C | B | A | r2| B | C | C | A | A | B | A | r3| A | A | C | B | B | C | C | c1 c2 c3 c4 c5 c6 c7 r1| A | B | C | B | A | r2| B | C | A | B | A | r3| A | C | B | C | I am hoping the solution might be relatively simple to do. Thanks in advance, Blair