I want to bind the grid to query results.
A person might appear several times and I want to sort the results using person ID.
Is there a way to hide duplicate values (e.g. ID, First name, Last name etc.) in the grid?

I wish there was a property like 'HideDuplicates'  in MS Access.

Hello Hanoch,

You can implement this functionality on database level. For example:

SELECT DISTINCT ID, FirstName, LastName FROM YourTable

Let us know if you need more information.

Best regards,
Daniel
the Telerik team

Thanks Daniel

But a DISTINCT won't help here since some columns will be different (such as order id, order date etc.)
I want the grid to look like in this example:
Man ID | Name    | Order ID | Order Date | Total Price
=========================================
|  101   | Joe K.   | 1001       | 1/1/09         | 50$  
|           |              | 1004       | 3/1/09         | 120$  
|  103   | Tim B.   | 1002       | 1/1/09         | 70$  
|           |              | 1003       | 4/1/09         | 100$  

As I said, a new GridBoundColumn's property called HideDuplicates will be nice.

Meanwhile, I managed to get what I wanted with this method:

1) I wrote this generic function:
        private Hashtable hashLastValues = new Hashtable();
...
        protected string myHideDuplicate(object oField,string FldName)
        {
            string CurValue = oField.ToString();
            if (hashLastValues.ContainsKey(FldName))
                if ((string)hashLastValues[FldName]==CurValue)
                    CurValue = "";
                else
                    hashLastValues[FldName]=CurValue;
            else
                hashLastValues.Add(FldName, CurValue);

            return CurValue;
        }

2) I defined columns in the grid like this:
            <telerik:GridTemplateColumn DataField="ManFamily" HeaderText="Last Name">
            <ItemTemplate>
            <asp:Label runat="server" Text='<%# myHideDuplicate(Eval("ManFamily"),"ManFamily") %>'></asp:Label>
            </ItemTemplate>
            </telerik:GridTemplateColumn>

And it's working fine now.

Hi here

I've also been looking into doing the same thing

but no success

how does your method work ?

Hello Brian,

You can merge the cells having duplicate values using the following code:
c#:

Hope this helps..
Princy.

Hi Princy,

Will it applicable for Silverlight RADGRIDVIEW also.
If yes, Can you please tell me how we can call this method/changes?

Please guide me to do.

Thanks,
Karthikeyan Manickam.

This solution is perfect, worked for me. Thanks Hanoch Faran.