This is a migrated thread and some comments may be shown as answers.

[Solved] Paging, Drag and Drop for grouping is not working for radgrid having default groupByexpression on Date in IE browser

1 Answer 132 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sunil
Top achievements
Rank 1
Sunil asked on 28 May 2013, 01:26 PM
we have a telerik radgrid in a usercontrol created programatically with default group by expression added programatically.
Issue we are facing is grid feature like paging, sorting, drag and drop on grouping panel doesnot work only on IE browser if default groupbyexpression added is for date field. Date field is stored in database as Datetime and we are retrieving as it is from database and formatting the column using radgrid's gridDatetimeColumn DataFormatString = "{0:MM/dd/yyyy}". 
Below is the code snipped used 

    For Each dc As DataColumn In RadGridList.DataSource.Columns
                Dim objcolentity As New BoundColsEntity()
                objcolentity = LstBoundColsEntity(LstColCount(dc.ColumnName))
                If objcolentity.visiblity = True Then
                    Select Case objcolentity.ColumnFilterType
                        Case "DateSelction"
                            Dim datecolumn As New GridDateTimeColumn
                            datecolumn.DataField = dc.ColumnName
                            datecolumn.UniqueName = dc.ColumnName
                            datecolumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
                            datecolumn.FilterControlWidth = Unit.Pixel(120)
                            datecolumn.ItemStyle.Height = Unit.Pixel(40)
                            datecolumn.HeaderStyle.Width = Unit.Pixel(170)
                            datecolumn.Visible = True
                            datecolumn.SortExpression = dc.ColumnName
                            datecolumn.PickerType = GridDateTimeColumnPickerType.DatePicker
                            datecolumn.EnableTimeIndependentFiltering = True
                            datecolumn.DataFormatString = "{0:MM/dd/yyyy}"
                            datecolumn.FilterListOptions = GridFilterListOptions.VaryByDataType
                            datecolumn.Groupable = enableGrouping
                            RadGridList.MasterTableView.Columns.Add(datecolumn)
                        Case "DBvalues"
                            Dim ComboFilterColumn As New DBFilter(dc.ColumnName, RadGridList.DataSource)
                            ComboFilterColumn.DataField = dc.ColumnName
                            ComboFilterColumn.UniqueName = dc.ColumnName
                            ComboFilterColumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
                            ComboFilterColumn.Visible = objcolentity.visiblity
                            ComboFilterColumn.ItemStyle.Height = Unit.Pixel(40)
                            ComboFilterColumn.HeaderStyle.Width = Unit.Pixel(objcolentity.width)
                            ComboFilterColumn.Resizable = objcolentity.Resizable
                            ComboFilterColumn.Reorderable = objcolentity.Reorderable
                            ComboFilterColumn.AllowSorting = objcolentity.enableSorting
                            ComboFilterColumn.Groupable = objcolentity.enableGrouping
                            ComboFilterColumn.FilterListOptions = GridFilterListOptions.VaryByDataType
                            ComboFilterColumn.AllowFiltering = True
                            ComboFilterColumn.ShowFilterIcon = False
                            RadGridList.MasterTableView.Columns.Add(ComboFilterColumn)
                        Case Else
                            Dim boundcolumn As New GridBoundColumn()
                            boundcolumn.DataField = dc.ColumnName
                            boundcolumn.UniqueName = dc.ColumnName
                            boundcolumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
                            boundcolumn.Visible = objcolentity.visiblity
                            boundcolumn.ItemStyle.Height = Unit.Pixel(40)
                            boundcolumn.HeaderStyle.Width = Unit.Pixel(objcolentity.width)
                            boundcolumn.Resizable = objcolentity.Resizable
                            boundcolumn.Reorderable = objcolentity.Reorderable
                            boundcolumn.AllowSorting = objcolentity.enableSorting
                            boundcolumn.Groupable = objcolentity.enableGrouping
                            boundcolumn.FilterListOptions = GridFilterListOptions.VaryByDataType
                            boundcolumn.HtmlEncode = True
                            Select Case objcolentity.ColumnFilterType
                                Case "StringContains"
                                    boundcolumn.AllowFiltering = True
                                    boundcolumn.ShowFilterIcon = False
                                    boundcolumn.FilterControlToolTip = "Hit enter to search"
                                    boundcolumn.AutoPostBackOnFilter = True
                                Case "NoFilter"
                                    boundcolumn.AllowFiltering = False
                                    If Not String.IsNullOrEmpty(objcolentity.headerType) Then
                                        boundcolumn.HeaderImageUrl = objcolentity.path
                                    End If
                                Case Else
                                    boundcolumn.ShowFilterIcon = True
                            End Select
                            RadGridList.MasterTableView.Columns.Add(boundcolumn)
                    End Select
                    If objcolentity.DefaultGrpByExp Then
                        Dim gridGrpByExp As New GridGroupByExpression()
                        Dim gridGroupByField As New GridGroupByField()
                        gridGroupByField = New GridGroupByField
                        gridGroupByField.FieldName = dc.ColumnName
                        gridGroupByField.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
                        gridGrpByExp.SelectFields.Add(gridGroupByField)
                        gridGroupByField = New GridGroupByField
                        gridGroupByField.FieldName = dc.ColumnName
                        gridGrpByExp.GroupByFields.Add(gridGroupByField)
                        RadGridList.MasterTableView.GroupByExpressions.Add(gridGrpByExp)
                    End If
                End If
            Next

1 Answer, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 31 May 2013, 08:34 AM
Hello Sunil,

We will need all of the grid definition to be able to replicate the issue locally. Please open a support ticket to send us a very basic runnable sample web site so we can reproduce the issue and debug the application accordingly. This will enable us to determine the cause of the problem and to provide an accurate solution.

Regards,
Eyup
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Sunil
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Share this question
or