Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Forms > Form Designer > Form Controls > Database Controls > DB Pivot Grid

Fields

Scroll Prev Top Next More

A DB Pivot Grid field represents a subset of data that corresponds to an R:BASE table column. Fields are visually represented by field headers which can be moved between the control's areas using drag-and-drop operations. Dragging fields between the areas modifies the layout of the form. To create a form with the DB Pivot Grid control, the fields should be created and positioned within appropriate areas using the following steps:

 

add a field object to the display;

specify the field's area and position within this area via the "Area" and "Area Index" properties.

 

A field can be positioned within one of four areas: the column, row, filter, and data areas.

 

ð Table Fields

Displays the available column fields

 

ð >>

Adds all the available fields to the display

 

ð >

Adds only the selected field to the display

 

ð <

Removes only the selected field from the display

 

ð <<

Removes all fields from the display

 

ð Edit Grid Field Definition EditCol

Sets the properties for the selected field

 

The list of field items are provided in a grid for review.

 

Field - displays the field name

Caption - displays the field caption

Area - displays the field area

Visible - displays if the field is visible

 

Notes:

 

The DB Pivot Grid field display sequence can be reordered by selecting the "Move Up" and "Move Down" buttons.

 

Right click within the fields to use the pop-up menu.

 

DBPivotGrid_EditFieldDef

DBPivotGrid_Fields