Data Grid

The Data Grid component is used to represent data in tabular form. Data Grid is also known as 'Grid View' as the data will be displayed within a grid.

Best Situation to Use Data Grid

When the end-user need to view data in numerical format. When alerts need to be shown.

Default Data Grid Chart Image

Properties of the Data Grid chart

General

• The user can also change the height, width, top, left, points, chart type.

• The user needs to put a checkmark for the Initial Visibility option to avail the preview at the first time.

• Use a checkmark in the Fit Columns to auto-fit the size of the columns.

• The user can also enable or disable Scroll View. In this case, the selected scroll view is 'Disable'.

Check out the given illustration on how to use the Column Rearrange property in the Data Grid.

Rearrange Column Property in the Data Grid component

Background

The user can change the background color of the chart, can get the border for the chart and can change the border color, can get the reflection of the chart by enabling the shadow option can also change the color and increase & decrease the transparency of the shadow.

Title

The user can change Title Name, Font color, size, style, etc.

Subtitle

The user can enable the subtitle to display the second title. The user can change the Name, Font color, size, style for the subtitle.

Header Style

The user can change the header text color, font size, font style, and background color.

Access Check Boxes for the Multi-selection of the Rows

Enable the Show Checkbox property from the General section and provide the "allowmultipleselection = true" in the Dashboard script to avail the checkboxes in the preview mode of the Data Grid.

Check out the given illustration on accessing checkboxes for the multi selection of the Grid Rows.

Implementing Checkbox property for the multi selection of the rows in the Data Grid

Row Style

The user can change the font size, font color, text decoration, and enable the text wrap. The user can also increase the row height.

Styles

The user can change the background color, rollover color, selection color, user can enable horizontal grid lines also can change the color for horizontal & vertical lines.

Export Options

The Export Options also helps to provide heading, subheading, file name. The user can also select an option for Global Export Type.

The user can enable the Enable Context Menu from the preview section to download the reports in downloaded chart and the name of the downloaded file can be changed from this section.

Properties Tab from the Dataset Pallet

Data Grid after changing the Properties

Please Note:

• The user needs to select the Column Type as Numeric for the selected Data Grid fields using the Properties tab provided for the Dataset, so they become responsive to the changes that the user set using the Indicator tab.

• Refer the Alerts in Grids page provided under Configurations section to understand how to insert Alerts in a Grid component.