Modifying Device Designs › Editing Report Designs › Example 2: Extended Report Design › County Report Segment

Previous Topic: Example 2: Extended Report Design

Next Topic: County Default Report Design

County Report Segment

If Area is divided into County as shown by the following relations:

FIL   Country  REF  Known by   FLD   Country code   CDE
FIL   Country  REF  Refers to  FIL   Area           REF
FIL   Country  REF  Has        FLD   Country name   TXT

Then to provide a sublisting of the counties for each area, you need a RSQ access path with the following entries:

Access Path Entries

Type

Key

County code

Country code

Area code

County name

A

A

A

A

K3

K1

K2

 

 

Note: This access path should be specified so that it has a unique key order.

A Print Counties in Area PRTOBJ function would be based on this access path. Country Code and Area Code would be made restrictor parameters so that only counties for a given area would be printed:

PRTOBJ Function

ACP

Keys on Access Path

USG

Counties in area

RSQ

1. Country code

2. Area code

3. County code

RST

RST