Grid forms

In WebDataRocks Pivot Table, data can be displayed in aggregated views or as a simple table. You can switch between three standard layouts to display the report data differently:

• Compact pivot table  – neat and concise data presentation.
• Classic pivot table – an Excel-like layout.
• Flat table – a simple grid with non-aggregated data.

Compact form

The compact pivot table form is enabled by default. This layout helps keep your data in a neat and concise style.

Features:

• Compact form enhances the readability of the report.
• If the rows contain more than one field, the members of the inner field can be expanded and collapsed by clicking on the outer field’s member name. 
• If the members of the field in the rows are expanded, they are placed one under the other, without being transferred to a separate column. 
• If the members of the field in the columns are expanded, they are placed in a separate row. 
• Subtotals are shown at the end of each row in a separate column.
• Grand totals are placed at the bottom in a separate row.

Classic form

The classic pivot table form suits perfectly those who would like to have an Excel-like user experience.

Features:

• If the rows contain more than one field, the members of the inner field can be expanded and collapsed by clicking on the outer field’s member name.
• If the members of the field in the rows are expanded, they are placed in a separate column. It is the main feature that distinguishes the classic layout from the compact one.
• If the members of the field in the columns are expanded, they are placed in a separate row. 
• Subtotals are shown in a separate row after each hierarchy in the rows.
• Grand totals are placed at the bottom in a separate row.

Flat form

The flat table form displays the data in a non-aggregated view, which reflects the data’s original raw structure. It’s the simplest form among the others.

Features:

• The data is shown without aggregation.
• Each field is placed in a separate column.
• Grand totals are placed in the first row.

To change the grid form

• Via UI
  1. Go to the Options tab () on the Toolbar.
  2. Select the form of your choice.
  3. Apply the changes.
• Programmatically
  Set a grid layout through the grid.type property of the Options Object:

  report = {
    options: {
      grid: {
        type: "classic"
      }
    }
  };

  It is also possible to set the grid.type option for all reports.