Sorting and Totaling

By default, the items reported on will be listed in the order that they are stored in the database.

You can specify which attributes will be used to sort the elements in the report and the type of sorting, for example, ascending or descending numerical order. If more than one attribute is used for sorting, you can control the precedence, that is which attribute is sorted first.

For this exercise, look at the template line_list.tmp by selecting Utilities > Standard Reporting > Reports > Modify on the Main Menu.

Note:
The sample templates are all for file reports, with runtime prompts set. If you want to try the examples, send the reports to the screen and switch the prompts off (use Options > Runtime Prompts on the New/Modify Report Template form).

This template reports on the Pipe Name, Specification, Head Bore, Tail Bore, Head Ref and Tail Ref of Branches. The template sorts the Branches in ascending order of Head Bore.

With the Hierarchy set to the Zone PIPES, the output will look like this:

Line List for WORLD

PIPE PSPEC HBORE TBORE HREF TREF

/50-B-9 /A3B 15.00 15 /50-B-9-B1-TEE2 =0/0

/40-B-10 /A3B 40.00 40 /40-B-10-B1-TEE1 /40-B-10-B1-TEE2

/100-B-1 /A3B 50.00 100 /P1502A-N2 =0/0

/100-B-1 /A3B 50.00 100 /P1502B-N2 /100-B-1-B1-TEE1

/50-B-9 /A3B 50.00 50 /P1501A-N2 /1101/N4

/50-B-9 /A3B 50.00 50 /50-B-9-B1-TEE4 /50-B-9-B1-TEE5

/50-B-9 /A3B 50.00 50 /P1501B-N2 /50-B-9-B1-TEE1

/40-B-10 /A3B 50.00 40 /50-B-9-B1-TEE3 =0/0

/80-A-11 /A1A 50.00 80 /80-B-14-B1 =0/0

/80-B-14 /A3B 50.00 50 /80-B-14-B1-TEE1 /80-A-11-B1-TEE1

/100-B-1 /A3B 80.00 80 /100-B-1-B1-TEE2 /100-B-1-B1-TEE3

/100-B-2 /A3B 80.00 80 /100-B-2-B1-TEE1 =71/608

/80-B-7 /A3B 80.00 80 /E1302A-S2 /D1201-N1

/100-C-12 /F1C 80.00 80 /100-C-12-B1-TEE1 /100-C-12-B1-TEE2

/80-B-14 /A3B 80.00 50 /D1201-N2 /80-A-11-B1

/100-B-2 /A3B 100.00 100 =0/0 /150-A-3-B1

/150-A-3 /A1A 100.00 150 /100-B-2-B1 =0/0

/100-B-8 /A3B 100.00 100 /D1201-N4 /P1501B-N1

/100-B-8 /A3B 100.00 100 /100-B-8-B1-TEE1 /P1501A-N1

/100-C-12 /F1C 100.00 100 =0/0 /1301/NS2

/100-C-13 /F1C 100.00 100 /1301/NS1 =0/0

/150-B-6 /A3B 150.00 150 /1101/N5 /E1302B-S1

/150-A-57 /A1A 150.00 100 =0/0 /P1502A-N1

/150-A-57 /A1A 150.00 100 /150-A-57-B1-TEE1 /P1502B-N1

/200-B-4 /A3B 200.00 200 /1101/N3 /1301/N1

/250-B-5 /A3B 200.00 250 /1301/N2 /1101/N2

/250-B-5 /A3B 200.00 250 /1301/N4 =72/615

Summary: 27 Lines in Schedule