The WinForms Dashboard Designer allows you to use two data processing modes that are responsible for performing data-related operations (such as grouping, filtering, etc.). These modes include server and client modes. To learn basic concepts about operating these modes, see Data Processing Modes.
Different data source types allow you to manage the current data processing mode in different ways:
For SQL data sources, you can switch between data processing modes manually. To enable or disable server mode for the selected data source, use the Server Mode button located on the Data Source ribbon tab.
Server mode is supported for the SQL data sources created using the Data Source wizard and supplied with data using the Query Builder. To set the data processing mode for the specified data source in code, use the DashboardSqlDataSource.DataProcessingMode property.
For all data source types, you can use the IDashboardDataSource.IsServerModeSupported property to determine whether or not the current data source supports server-side data processing.
In server mode, the Dashboard does not have simultaneous access to bound data in its entirety. This imposes the following limitations:
The Count Distinct summary function is not supported for the following database engines:
The Dashboard Designer provides the capability to display errors that occurred during data processing operations (such as changing measure summary types, calculation errors, etc.). For instance, the Grid below shows an error when the summary type of the Extended Price measure is set to Median in server mode.
To see the error message, hover the mouse pointer over the icon.