This property is called suppress duplicates or hide duplicates and is available on most of the front end reporting tools. You can find this property within textbox properties in SSRSDoing this in SQL is ugly as its a presentation issue.However if you really have no other choice use the belowSELECT CASE WHEN Seq=1 THEN lname ELSE '' END AS lname,cperson, desig,cno, extnno, faxno, mobilno, locationFROM(SELECT ROW_NUMBER() OVER (PARTITION BY lnamefield ORDER BY cno) AS RN,...... Rest of your query)t
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs