Design Dashboard > DB-Design

Grid View is also known as Data Grid. It is a graphical Control Element in which data is displayed in the tabular Form (In the form of tables). The Grid View control enables you to select, sort, and edit various items. It is commonly used to display lists of data and information through some common known field items like Company Name, Party Name, Net Amount, Sale Quantity etc..

New Grid View Creation:

Click on the Add Sheet to add a Grid View in your DB-Design. Then, click on Add Grid View from the top options of the window.

Right click on the existing sheet (Filter List) and Click on the Add Sheet. Then, Click on the New Sheet Object and then, Grid View option.

Grid View Create

Fig 1. Create Grid View

Grid View Properties window will appear on your screen. See window below:

You will see two tabs on the top of the window. One is for Dimensions/ Measures and another is for General Properties.

In the middle of the window, there are two sets of arrow buttons. One is for Single arrows and another is Double arrows. Single arrow is used to transfer the items from Table field to Selected Field and Double Arrows are used to transfer it from Selected Field to Table Fields.

Use Arrows to transfer your items from Table Fields to Selected Fields. See the window below:

1) You can also Double click on the item to transfer it from one table to another.

2) You can change the header name of every field and the changed name will be visible in the DB-Design.

Grid View Properties

Fig 2. Grid View Properties

Grid View Properties

Grid View Chart Properties could be of two types. You need to categorize your items as per its properties. These properties are as mentioned below:

Dimensions/ Measures

General

1.	Dimensions/ Measures

Dimensions/ Measures could be of three types. You need to select your required features from these properties available. These are as follows:

1) Dimensions

Fig 3. Dimension

Dimensions Properties: Dimensions are the alpha numeric header given to a Field Item for representing quantitative display of data. Dimensions are those things you want to track.

Header

You can change the header name of any field from the first properties of Dimension tab. Select any item from Selected Field and click on the Header Tab. For example: In the below window Company Name is changed to Brand Name.

It can be viewed in the DB-Design View as well.

Fig 4. Header

Header Alignment

You can change the alignment of the header through this option. There are three types of Header Alignments available: Left, Right and Center. There should be space for the text in the header to move in.

See the Center Header Alignment in the below example:

Fig 5. Header Alignment

Text Alignment

You can change the alignment of the text through this option. There are three types of Text Alignments available: Left, Right and Center.

See the Center Text Alignment on Pack Size in the below example:

Fig 6. Text Alignment

2) Measures

Fig 7. Measure

Measures Properties: Measures are the quantities you want to measure. Such as: Sale Quantity, Net Amount etc.

Header	You can change the header name of any field from the first properties of Measure tab. Select any item from Selected Field and click on the Header Tab. For example: In the below Net Amount is changed to Total Amount. It can be viewed in the DB-Design View as well. Fig 8. Header
Header Alignment	You can change the alignment of the header through this option. There are three types of Header Alignments available: Left, Right and Center. There should be space for the fields to move through.
Text Alignment	You can change the alignment of the text through this option. There are three types of Text Alignments available: Left, Right and Center. See the Left Text Alignment in the below example: Fig 9. Text Alignment
Aggregation	You have the option to decide the type of Aggregation system to be used while tabulating the report. Aggregation is a function where different values are of multiple rows are grouped together on a certain criteria to form a single value. For example: Average Aggregation is applied on the Net Amount field in the below window: Fig 10. Aggregation
Footer Visibility	If you want to show the Footer in the Grid View by simply selecting the Footer Visibility option Visible. Fig 11. Footer

3) Order

Fig 12. Order

Order Properties: You can change the order of the fields through Order Properties. You can keep the items on your desired number through this option.

Sort By

You can sort the properties in two ways ascending and descending order. Sort By option allows you to sort in the desired order.

Fig 13. Sort By

Up & Down

Up and Down buttons allow you to change the position of the field items upward and downward.

Select the item you want to move and click on up or down from the Order Properties.

Fig 14. Up & Down

2. General

General Tab is used to change the General Settings of the Chart.

Fig 15. General Properties

Visibility

Grid Settings

Header Settings

General

Visibility

You can control what to show in your Grid View through this option. It allows you to control the visibility of Row Header, Column Header and Toolbar. If you want to show it, click on the Checkbox.

Fig 16. Visibility

Grid Settings

Grid Settings allow you to Change the Foreground Color, Border Settings, Font Settings and Set Record Limit of the Grid.

Fig 17. Grid Settings

Header Settings

Header Settings is used to change the header with respect to Foreground Color, Border Settings and Font Settings.

Fig 18. Header Settings

After Applying all the properties, Final Grid View will look as follows:

Grid View Final

Fig 19. Grid View Final