<< Click to Display Table of Contents >>

Vertical division

Divide a group dataset in a group data store into multiple datasets vertically.

Vertical division is widely used to implement master/detail relationship. Original dataset is divided into master group dataset, detail dataset and detail group dataset.

To design above report example, first create a dataset including employee and department data.

Code

Department

Location

Employee

Position

Salary

10

ACCOUNTING

NEW YORK

CLARK

MANAGER

2572.2

10

ACCOUNTING

NEW YORK

KING

PRESIDENT

5500

10

ACCOUNTING

NEW YORK

MILLER

CLERK

920

20

RESEARCH

DALLAS

JONES

MANAGER

3123.75

20

RESEARCH

DALLAS

CHAN

ANALYST

3450

30

SALES

CHICAGO

ALLEN

SALESMAN

1600

30

SALES

CHICAGO

MARTIN

SALESMAN

1312.5

The original dataset can be vertically divided into two data group dataset, i.e., employee dataset and department dataset. Data of each dataset and division condition are as follows:

Note

Vertical division and horizontal division can be used together.