Automatic Formatting of results

[Kurt Kluth]

Is it possible to format the RadGrid results a certain way automatically?  It appears that the filtering items automatically choose which items are available based on the text in the column.  ie. If it is text, it adds the option "starts with" but if it is a number than it has other options so

What I would like is if it is determined to be a # account that it will properly format the results with commas. 

I had found where if I put it in the RadGrid_ColumnCreated, that I could do it there but I would have over 200 columns to possibly check.

[Kurt Kluth]

Have found the solution to my problem. 

Protected Sub _SearchResults_ColumnCreated(sender As Object, e As Telerik.Web.UI.GridColumnCreatedEventArgs) Handles _SearchResults.ColumnCreated
        If e.Column.DataType.Name = "Decimal" Then
            CType(e.Column, Telerik.Web.UI.GridBoundColumn).DataFormatString = "{0:N2}"
            CType(e.Column, Telerik.Web.UI.GridBoundColumn).Groupable = True

            CType(e.Column, Telerik.Web.UI.GridBoundColumn).Aggregate = Telerik.Web.UI.GridAggregateFunction.Sum
            e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right
        End If

        'Specify the location of the Images
        e.Column.FilterImageUrl = "../images/Grid/Filter.gif"
        e.Column.SortAscImageUrl = "../images/Grid/SortAsc.gif"
        e.Column.SortDescImageUrl = "../images/Grid/SortDesc.gif"
    End Sub