EXAMPLE:

SET SPACING double SET SPACING 5

PURPOSE:

Normally, the output report is single spaced. For double spacing, type SET SPACING DOUBLE, etc. For 10 blank lines between printed lines, type SET SPACING 11.

6.25.16 SET TSUPPRESS [ON | OFF]

FORMAT:

SET TSUPPRESS [ON | OFF]

EXAMPLE:

SET TSUPPRESS ON SET TSUPPRESS OFF

PURPOSE:

If TSUPPRESS is set on, minor level break totals will be suppressed if there is only 1 item (e.g. line) printed on the report. Only the printing of the subtotals is suppressed, not the processing of the total amounts.

6.26 SHOW Commands

FORMAT:

SHOW COMMANDS SHOW FIELDS [IN structure_name] SHOW OPEN SHOW STRUCTURES [IN device_directory_spec] SHOW COLUMN nn

SHOW COMMANDS

Displays the commands currently entered.

The SHOW COMMANDS command instructs GQL to display all commands previously input by the user in a current session.

SHOW FIELDS [IN structure_name]

Displays the fields for the named structure. If no structure is named, the fields in the primary structure (the first one opened) are displayed. Key fields are in BOLD print.

SHOW FIELDS
SHOW FIELDS IN CUSTOMER

SHOW OPEN

Displays the structures currently open.

SHOW STRUCTURES

Displays the structures found in the GUIDE_NAMES structure.

SHOW STRUCTURES IN device_directory_spec

Displays a directory listing of structure files in the specified directory.

SHOW STRUCTURES IN tti_run:
SHOW STRUCTURES IN USER:[FRED]

SHOW COLUMN nn

Displays the numerical starting position (e.g., 33) and other information for a column.

6.27 SORT

FORMAT:

SORT [ASCENDING | UP | DESCENDING | DOWN] [ON | BY] structure(field) [, structure(field), ...]

EXAMPLE:

SORT DESCENDING BY customer(days_past_due) SORT BY customer(custnbr)

PURPOSE:

The SORT command causes the records in the primary structure to be sorted in the order given.

The SORT command should precede the BREAK command if both are used.

ADDITIONAL:

SORT can order the records in either ASCENDING or DESCENDING order. ASCENDING creates a list in ascending order (lowest to highest) and is the default order. DESCENDING creates a list in descending order (highest to lowest).

GQL does sorts in order. Therefore, you can use multiple sorts to order the print on multiple levels. For example, if GQL is directed to first sort by product number and then by lineid, the products are sorted first by product number and then by line id.

Example 6-29 Example of SORT Command

OPEN CLIENT INCLUDE CLIENT(ID) > '80500' SORT CLIENT(LAST) ASCENDING PRINT CLIENT(ID) PRINT CLIENT(LAST) PRINT CLIENT(FIRST) PRINT CLIENT(CITY) PRINT CLIENT(STATE) GO

Example 6-30 Example of SORT Command - Output

23-Jan-1999 Report on CLIENT Page 1 CLNT Last First ID Name Name City ST ----- ----------------- --------------- ------------------------- -- 80542 Brock Bud Duluth MN 80543 Cass Cathy CA 80561 Derringer Dale CA 80522 Errant Earl CA 80573 Farmer Fred Miami FL 80544 Porter

6.28 SUMMARY

FORMAT:

SUMMARY

EXAMPLE:

SUMMARY

PURPOSE:

The SUMMARY command causes GQL to generate a summary report. The summary report is a shorter form of the full (detailed) report. In a summary report, a line is printed every time the lowest level break occurs, instead of printing every record.

Example 6-31 Example of SUMMARY Command, Part 1 - Full Detail

OPEN DETAIL SORT BY PRODNBR SORT BY LINEID INCLUDE INVNBR < 10330 EXCLUDE INVNBR = 10320 BREAK ON PRODNBR SET GRANDTOTAL 'Extended price grand-total:' POSITION 2 PRINT PRODNBR GROUP 1 PRINT LINEID PRINT QTY PRINT PRICE PRINT EXTPRICE WITH TOTALS GO

Example 6-32 Example of SUMMARY Command, Part 1 - Full Detail - Output

23-Jan-1999 Report on DETAIL Page 1 Line Prod Item Order Selling Extended Nbr ID# Qty Price Price ----- --------- ------ ---------- ---------- 20120 10304-002 2 1,495.00 2,990.00 10323-004 1 1,495.00 1,495.00 ========== 4,485.00 22600 10314-002 1 325.00 325.00 10323-005 1 325.00 325.00 10327-002 1 325.00 325.00 10328-002 1 325.00 325.00 10328-003 4 325.00 1,300.00 10329-003 2 325.00 650.00 ========== 3,250.00 . . . . 33090 10301-007 2 1,495.00 2,990.00 10303-001 1 1,495.00 1,495.00 10311-007 1 1,495.00 1,495.00 10322-004 4 1,495.00 5,980.00 10325-002 2 1,495.00 2,990.00 ========== 14,950.00 33180 10304-001 1 2,095.00 2,095.00 10308-002 1 2,095.00 2,095.00 10315-001 2 2,095.00 4,190.00 ========== 8,380.00 ========== Extended price grand-total: 135,900.00

Example 6-33 Example of SUMMARY Command, Part 2 - Summary

OPEN DETAIL SUMMARY SORT BY PRODNBR SORT BY LINEID INCLUDE INVNBR < 10330 EXCLUDE INVNBR = 10320 BREAK ON PRODNBR SET GRANDTOTAL 'Extended price grand-total:' POSITION 2 PRINT PRODNBR GROUP 1 PRINT LINEID PRINT QTY PRINT PRICE PRINT EXTPRICE WITH TOTALS GO

Example 6-34 Example of SUMMARY Command, Part 2 - Summary - Output

23-Jan-1999 Report on DETAIL Page 1 Line Prod Item Order Selling Extended Nbr ID# Qty Price Price ----- --------- ------ ---------- ---------- 20120 10323-004 1 1,495.00 4,485.00 22600 10329-003 2 325.00 3,250.00 22800 10325-003 10 375.00 8,625.00 24100 10329-002 1 199.00 2,786.00 24200 10329-004 3 299.00 3,887.00 28120 10329-005 2 379.00 6,443.00 28400 10327-001 3 149.00 1,639.00 28800 10329-007 1 249.00 8,715.00 30170 10329-001 2 1,595.00 15,950.00 31020 10328-005 9 595.00 7,140.00 31030 10321-001 2 795.00 4,770.00 31040 10326-002 2 995.00 9,950.00 31150 10329-006 1 2,495.00 34,930.00 33090 10325-002 2 1,495.00 14,950.00 33180 10315-001 2 2,095.00 8,380.00 ========== Extended price grand-total: 135,900.00

6.29 TITLE

FORMAT:

TITLE 'title_text'

EXAMPLE:

TITLE 'Daily Invoice Report' TITLE "Fred's Customer List"

PURPOSE:

The TITLE command sets up a report title which will be printed at the top of each page of the report.

ADDITIONAL:

Each TITLE command sets up a successive title line, up to a maximum of nine (9) title lines.

Until a title is entered for a report, a default title is assigned. The default title is "Report On <structure_name>". One to no more than nine title lines are permitted.