Server Mode and Instant Feedback Limitations
- 3 minutes to read
In server mode, the GridControl does not have simultaneous access to bound data in its entirety. This imposes some limitations on the grid’s features, which are still available in regular binding mode. This topic lists the Server and InstantFeedback Modes limitations.
Data Editing
Adding/deleting records via the Grid Control when data is grouped is not supported.
Sorting
The following features are not supported:
- Sorting data by displayed values (not by editing values).
- Custom data sorting via the GridControl.CustomColumnSort event.
- Sorting for unbound columns whose values are provided via the GridControl.CustomUnboundColumnData event. Sorting is still supported for unbound columns that are populated using expressions (see ColumnBase.UnboundExpression).
- Sorting for columns that are bound via the ColumnBase.Binding property.
Grouping
The following features are not supported:
- The ColumnGroupInterval.Alphabetical and ColumnGroupInterval.DisplayText group modes.
- Custom data grouping via the GridControl.CustomColumnGroup event.
- Merged grouping within all the data sources except the XPServerCollectionSource.
- Grouping of unbound columns whose values are provided via the GridControl.CustomUnboundColumnData event. Grouping is still supported for unbound columns that are populated using expressions (see ColumnBase.UnboundExpression).
- Grouping for columns that are bound via the ColumnBase.Binding property.
Filtering and Searching
The following features are not supported:
- Filtering data by displayed values (not by editing values).
- Filtering rows using custom rules implemented within the GridControl.CustomRowFilter event handler.
- Data filtering via Search Panel for non-string columns.
- Incremental Search feature.
- WcfServerModeDataSource, WcfInstantFeedbackDataSource and RiaInstantFeedbackDataSource do not support data filtering by the following conditions: Like, Not Like, and special DateTime conditions (Yesterday, Tomorrow, Last Week, etc.).
- When searching using the Search Panel, the grid always converts a search string to lower-case. Thus, when binding the Grid Control to a case-sensitive data source, data search results will not contain target entries that have text in upper case. To overcome this issue, use a case-insensitive data source. See the following article to learn more:How to make the Grid’s filter to be a case- and accent-insensitive in Server Mode.
- Filtering for unbound columns whose values are provided via the GridControl.CustomUnboundColumnData event. Filtering is still supported for unbound columns that are populated using expressions (see ColumnBase.UnboundExpression).
- Filtering for columns that are bound via the ColumnBase.Binding property.
Selection
Preserving the row selection when data is sorted, grouped or filtered is not supported.
Summary Calculation
The following features are not supported:
- Calculating custom summaries by handling the GridControl.CustomSummary event. The GridControl.CustomSummaryExists event does not work.
- Summary calculation for unbound columns whose values are provided via the GridControl.CustomUnboundColumnData event. Sorting is still supported for unbound columns that are populated using expressions (see ColumnBase.UnboundExpression).
Data Sources and Presentation
The following features are not supported:
- Data values rounding.
- The top/bottom conditional formatting rules (Top10Items, Top10Percent, Bottom10Items, Bottom10Percent, AboveAverage, BelowAverage).
Functional limitations:
- The maximum number of visible data groups is limited to 10000.
- Server mode and Instant feedback mode cannot be used in master and detail grids.
- The GridControl.GetRowHandleByListIndex method does not return the correct value.
- Server mode and Instant feedback mode do not support unbound column printing.
- Compound keys are only supported by LinqServerModeDataSource, LinqInstantFeedbackDataSource, EntityServerModeDataSource, EntityInstantFeedbackDataSource, XPServerCollectionSource and XPInstantFeedbackSource.
Fixed Rows
Fixed Rows are not supported.
Possible Performance Issues
The GridControl.AutoExpandAllGroups and GridControl.IsRecursiveExpand properties may cause performance issues in GridControl used in Server Mode.
Expanding each group row requires sending a request to an SQL server. When a column participating in grouping has too many unique values, it creates many group rows. Expanding all of them at once may lead to sending a large number of SQL queries, which may take a lot of time to execute.