Data Processing Modes

• Apr 05, 2019
• 3 minutes to read

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.

• Change Data Processing Mode
• Server Mode Limitations
• Data Processing Errors

Change Data Processing Mode

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.

• The Entity Framework data source does not allow you to switch between data processing modes manually, but enables server mode automatically for properties returning objects implementing the IQueryable interface. Use the DashboardEFDataSource.GetDataProcessingMode property to determine the data processing mode for the specified data member contained in the data source.
• Excel Data Source and Object Data Source support client mode only.
• Extract Data Source works in client mode and allows you to manage its in-memory cache using the ExtractCacheOptions.DefaultCache property.

For all data source types, you can use the IDashboardDataSource.IsServerModeSupported property to determine whether the current data source supports server-side data processing.

Server Mode Limitations

In server mode, the Dashboard does not have simultaneous access to bound data in its entirety. This imposes the following limitations:

• Stored procedures are not supported in server mode.
• Stored procedures executed using custom SQL are not supported in server mode.
• Some calculated fields cannot be evaluated in server mode.

• The Count Distinct summary function is not supported for the following database engines:

  • Microsoft Access
  • Microsoft SQL Server CE
• The Median summary function is supported for the Oracle data provider only.
• The Mode summary function is supported for the Oracle and PostgreSQL data providers only.

• The Bound Image and Grid dashboard items can display images only from the following types of databases:

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL

Data Processing Errors

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.