Manage Data Inspector in the WinForms Designer
- 3 minutes to read
Data Inspector is a dialog window that displays raw or aggregated data. The window can contain one or two grids depending on chosen options. A user can employ the radio group located at the window top to switch between grids.
#Aggregated and Raw Data
- Aggregated Data
- Aggregated Data is retrieved from the dashboard item’s data storage that is the MultiDimensionalData object. For more information on how Aggregated Data is displayed in Data Inspector, refer to the following article: Aggregated Data.
- Raw Data
- Raw data is the dashboard item’s underlying data. For more information on how Aggregated Data is displayed in Data Inspector, refer to the following article: Raw Data.
#Enable Data Inspector
The Inspect Data button and the corresponding menu item are initially hidden. To show them, set one of the following properties to true
depending on the data you want to display:
//...
public Form1() {
InitializeComponent();
dashboardDesigner1.AllowInspectAggregatedData = true;
dashboardDesigner1.AllowInspectRawData = true;
}
To invoke the Data Inspector window in the UI, click the Inspect Data button in the dashboard item caption or select the Inspect Data context menu item:
When only one property is set to true
, the window contains a single grid with raw or aggregated data, depending on what property is enabled. The window caption displays the dashboard item caption text and the inspected item type (raw or aggregated) in parentheses.
When both properties are set to true
, the window contains two grids with raw and aggregated data and allows a user to switch between them. The window caption displays the dashboard item caption text.
Data Inspector can display hidden measures and does not display hidden dimensions. You can add data members to the Hidden Measures section to display them only in the Data inspector and keep visual data unchanged.
#Customize Data Inspector
Call the ShowDataInspector
method to invoke the Data Inspector dialog:
To customize the Data Inspector dialog, use the following API:
- DashboardDesigner.DataInspectorFormLoad
- Occurs before the Data Inspector window displays. Allows you to access the window’s grid controls and change their settings.
- DashboardDesigner.DataInspectorFormClosing
- Occurs before the Data Inspector window closes. Allows you to access the window’s grid controls.
- DataInspectorFormLoadEventArgs.AllowExportAggregatedData
- Gets or sets whether end users can export aggregated data from the Data Inspector.
- DataInspectorFormLoadEventArgs.AllowExportRawData
- Gets or sets whether end users can export raw data from the Data Inspector.
#Export Data
Data Inspector allows you to export data in different formats.
Use the Print Preview dialog to export data in the desired format (Excel, PDF, Image, etc.)