I am developing using SSRS 2005. I am usung the solution on this web site: http://www.itjungles.com/reporting-services/reporting-services-merge-cells It seems like the solution is working with the exception when I add a background color to the textbox with the code, then the lines get all messed up, I am not sure why a background color would throw it off. The value property for the text box=IIF((Previous(Fields!Site_Code.Value)=Fields!Site_Code.Value) , "", Fields!Site_Code.Value) Borderstyle property for the textbox =None, None, None, =IIF((Previous(Fields!Site_Code.Value)=Fields!Site_Code.Value) , "None", "Solid"), None Any ideas or other solutions would be helpful DBA Developer

Hi, "The value property for the text box=IIF((Previous(Fields!Site_Code.Value)=Fields!Site_Code.Value) , "", Fields!Site_Code.Value)" you can set the detail cell's HideDuplicate property so that the duplicated cell value will be hidden. "Borderstyle property for the textbox =None, None, None, =IIF((Previous(Fields!Site_Code.Value)=Fields!Site_Code.Value) , "None", "Solid"), None" it is hard to achieve in SSRS 2005(subreport might do it), but it is default feature if you group on the column and its duplicated values will be merged within the generated column automatically in SSRS 2008. thanks, Jerry