$ $ $ -- Work at DCL level GUIDE clears the screen and passes to DCL command level. When you have finished working at DCL level, press Return. %INCLUDE %INCLUDE %INCLUDE - Include a user-written routine The %INCLUDE statement is used to load user-written routines into the program that GUIDE creates. The included file can contain several routines. These routines can be validation routines for the input statements or routines that are run each time we get a record from the file specified in the OPEN statements. GUIDE will check that the file exists. It does not do any syntax checking of the code contained within the file. This statement is used to include the user-written routines specified in the input statement or in the OPEN statement. The default extension for include files is ".INC" Format: %INCLUDE CHECK_ACCOUNT.INC Related topics: 'set input routine' input_routine input open ADD ADD APPEND APPEND APPEND - Append previously saved commands to the current report Format: APPEND guide_filename Use this command to append to the current report you are working on, commands that you have previously saved in another file. If there are commands that you use in several reports, you can store them in a file, and append them later to all the reports that need them. Related topics: new old output BREAK BREAK BREAK - Do a level break Format: BREAK [ON] expression [, ...] [PAGE] [DESCRIPTION text] [POSITION column expression] expression Field or other information to break on. This is usually a field, but it can be any INTOUCH expression. PAGE Go to the top of the page after the level break. DESCRIPTION Descriptive text to be printed when this level break occurs. POSITION The column position at which the descriptive text will be printed. The default position will cause the description to end one space to the left of the start of the first column total. NOTOTALS Suppresses the printing of totals when this level break occurs. Example: sort by state break on state description "State totals" position 20 print state group 1 Use BREAK to indicate where level breaks will occur in the report. Use BREAK after you SORT records in a particular order. At a level break, GUIDE prints subtotals for any columns printing totals. In most cases, you should break in the same order that you sort. Related topics: 'print group' group 'print position' position 'break page' page sort BREAK PAGE PAGE BREAK..PAGE - Go to the top of the next page after a level break. Format: BREAK ... PAGE Example: break on custnbr page Related topics: break 'print group' group sort 'title' 'page heading' COMMANDS COMMANDS List of the commands and brief description of each APPEND Append a saved report format to current one BREAK Do a level break CONDITION Establish a variable for true/false test CUME Print a cumulative total EDIT Edit the report commands EXCLUDE Exclude records EXCLUDE FOUND Exclude records found in a related structure GO Produce the report HELP Print this help message IF Conditionally assign value to variable INCLUDE Include records INCLUDE FOUND Include only records found in a related structure INPUT Ask the user to enter data for use in producing the report LET Assign value to variable NEW Start a new report; clear memory OLD Bring in a previously saved report format OPEN Open structure OUTPUT Name the output listing report file PERCENT Print a percentage PROGRAM Name the INTOUCH program that GUIDE produces PRINT Print fields REFRESH Refresh screen RELATE Relate (connect) two structures SET Set various parameters SETUP Set up a structure SHOW Show information $ Enter DCL commands Related topics: output-commands screen-commands 'vocabulary file' CONDITION CONDITION Condition - Allows the user to define true or false condition statements Format: CONDITION variable-name IS condition The condition statement allows the user to simplify complex include and exclude criteria. Example: without using the condition statement OPEN STUDENT INCLUDE (GPA >= 3.0 AND UNITS_ATTEMPTED >= 12.0) OR & (GPA >= 2.5 AND UNITS_ATTEMPTED >= 18.0) Example: using the condition statement OPEN STUDENT CONDITION A IS GPA >= 3.0 AND UNITS_ATTEMPTED >= 12.0 CONDITION B IS GPA >= 2.5 AND UNITS_ATTEMPTED >= 18.0 INCLUDE A OR B Related Topics: include exclude CREATE CREATE The CREATE procedure creates a data file for a structure. If you are setting up a structure for an existing data file, you do not need to use CREATE. Choose CREATE by typing CREATE at the "Procedure" prompt. CREATE asks several questions about the data file. The exact questions depend on which record management system you are using. Related topics: setup 'setup data file' 'data file' 'setup record system' 'record system' 'create rms' rms CREATE RMS RMS Create RMS data file The program asks several questions about the data file to create: File organization? Record size? Primary key? Duplicates allowed? After you have answered all the questions, the program asks: Proceed with file creation (Y/N)? Answer YES if you are ready to create the data file. For RMS files, the program also creates an .FDL (file description language) file, which you can use later on with VMS commands such as CREATE/FDL, EDIT/FDL, and CONVERT/FDL. Related topics: setup 'setup show' 'setup show' CUME CUME CUME - Cumulative (running) total Format: CUME expression Example: print detail(amount), cume detail(amount) Related topics: print total totals DEFINE DEFINE DEFINE -- Define fields in a structure To choose this procedure, type DEFINE at the "Procedure?" prompt. The program asks you for the name of the field, and then for information about the fields: Field name Description Data type First position Field length Attributes Prompt text Column heading Print mask Screen mask Help text Access rules Related topics: setup 'field name' name 'field description' description 'field data type' 'data type' 'field position' position 'field length' length 'field attributes' attributes 'field prompt' prompt 'field heading' heading 'field print mask' 'print mask' 'field screen mask' 'screen mask' 'field help text' 'help text' 'field access rules' 'access rules' EDIT EDIT EDIT - Edit report commands with screen editor Format: EDIT This command calls the full screen editor of your choice so that you can modify the commands for your report. If you are using the TTI editor, here are a few commands to help you get started: Arrow keys Move around Delete Delete character to left of cursor Help Print help message PF2 Print help message Control-Z Exit F10 Exit SHOW FIELDS Show fields in a structure Related topics: save EXCLUDE EXCLUDE EXCLUDE - Exclude records Format: EXCLUDE expression[, expression[, ...]] EXCLUDE FOUND structure_name The EXCLUDE command removes the records you indicate from the group being printed in the report. If you enter more than one EXCLUDE expression, any expression that is true will exclude a record. Examples: exclude customer(balance) < 50 exclude customer(days_past_due) < 15 Related topics: 'exclude found' found include sort EXCLUDE FOUND FOUND EXCLUDE..FOUND - Exclude a record if it is found in the structure given. Format: EXCLUDE FOUND structure Example: exclude found customer Related topics: exclude include relate EXIT EXIT EXIT -- Exit from GUIDE To exit from GUIDE, use the EXIT command, or press Control-Z or F10. EXPORT EXPORT Exporting data When GUIDE is told to MAKE an EXPORT file, GUIDE will produce a comma seperated output file. In this file, all print expressions that produce string data will be printed within quotes. All of GUIDE's record selection, sorting, and printing abilities are available. related topics: make export_structure EXPORT_STRUCTURE EXPORT_STRUCTURE Exporting a Structure When GUIDE is told to MAKE an EXPORT STRUCTURE, GUIDE will produce an INTOUCH structure. An export structure will be named with "_GQLEXP" appended to the output name. A structure consists of the following filetypes: .STR - a file that contains the definition and data file names .DEF - the structure definition file - contains field definitions .DAT - the data file .FDL - the VMS File Definition Language file used to create the data file All fields that are "printed" will be added to the exported structure as fields. The default field name will be "COL" plus a sequential number. For example the first field "printed" will be "COL001". Guide will create the definition for each field with the attributes known at the time Guide is run. Column headings and print masks will be used in the definition file. Field scale is determined from the print mask. All of GUIDE's record selection, sorting, and printing abilities are available. related topics: make print EXPRESSION EXPRESSION Expression Many places in GUIDE, you can enter either a single field name or a more complex expression. The simplest type of expression is a field name. If the field is from the first structure you opened, just enter the field: print custnbr If the field is from another structure, name the structure and put parentheses around the field: print invoice(custnbr) In an expression, you can add two fields together, subtract, multiply, divide, raise to a power, use INTOUCH functions, use logical expressions, concatenate strings, etc. For more information on expressions, see the INTOUCH Language Guide. Here are some examples of expressions: amount invoice(date) rate * time rate / 100 first_name + ' ' + last_name days(invoice(date)) Related topics: field variable FIELD FIELD A field is a group of related characters in a data record, such as a name, street, city, phone number, or customer balance. To refer to a field, enter the structure name, followed by the field name within parentheses. Example: customer(state) If the field is from the first structure you open, you can omit the structure name and just enter the field name: state Related topics: expression variable 'field attributes' attributes 'field data type' 'data type' 'field description' description 'field heading' heading 'field help text' 'help text' 'field length' length 'field name' name 'field position' position 'field print mask' 'print mask' 'field prompt' prompt FIELD ACCESS RULES RULES Access Rules Access rules determine who will have access to a field. NORMAL lets users add, read, and change field information. Related topics: define 'field help text' FIELD ATTRIBUTES ATTRIBUTES Field Attributes Field attributes indicate characteristics of a field. You can enter one or more attributes. Separate multiple attributes with commas. DATE [:format] This field contains a date. A date field must be six or eight characters long. format Format for entering a date. Formats are YMD (default) and MDY. Note: At present, INTOUCH does not check the date attribute when storing a field. The attribute is available for the programmer to check. EB Store information as EBCDIC coded characters. LS For negative numbers, store a minus sign as the far left character. NUM [:scale] Allow numbers only. scale Scale factor--how many decimal places to use. RJ Right-justify data. Numeric fields are automatically right-justified. RS Store negative numbers with a minus sign on the far right. UC Uppercase all letters. ZF Zero fill on the left. ZS Suppress leading zeros; convert to spaces. NONE None of the attributes above. If you don't want any attributes, enter NONE at the prompt. Related topics: define field field 'field length' length 'field prompt' prompt FIELD DATA TYPE TYPE FIELD DATA TYPE -- Data type of a field The data type is the way a field is stored in a data file. Data types: CH Character; ASCII characters in image format. C3 COBOL comp-3, also called packed decimal. This type also supports VAX DECIMAL data type. FLOAT Floating point INTEGER Integer IU Unsigned integer UN Undefined ZN Zoned punch, used by DIBOL DS Date Length 6: IBIS date Length 8: VMS date-time stamp Related topics: define field 'field description' description 'field position' position FIELD DESCRIPTION DESCRIPTION A field description is a brief explanation of a field. A description can be up to thirty characters long. For a new field, the default description is the field name. Related topics: define field 'field name' name FIELD HEADING HEADING Heading The heading is used as a column heading in reports. For a new field, the default is the description. Some utilities, such as GUIDE, split headings into separate lines at commas. For example: "Line,Item,No" becomes Line Item No You may want to capitalize words in the heading so that they look good, as in the example here. Related topics: define field 'field prompt' prompt 'field print mask' 'print mask' FIELD HELP TEXT TEXT Help Text The help text for a field is text that you can display at data entry time to help the user in entering data. The help text can be up to 70 characters long. Besides this help text, you can also provide help with the HELP include module. Related topics: define field 'field screen mask' 'screen mask' 'field access rules' 'access rules' FIELD LENGTH LENGTH Field Length The field length is the number of characters a field contains. A field can be any length. In SETUP, instead of entering a field length, you can enter the ending position by typing "P" and the number. Example: Length? P46 Related topics: define field 'field position' position 'variable length field' 'field prompt' prompt FIELD NAME NAME FIELD NAME A field name identifies a field you want to work with. A field name o must begin with a letter o may consist of letters, digits, and underscores '_' o may be up to 32 characters long In SETUP, you can delete a field by entering a minus sign '-' and the field name. Example: '-FIRSTNAME'. If you have no more fields to define, type EXIT or press Control-Z. In GUIDE and INTOUCH, you can indicate a field by entering the structure name followed by the field name within parentheses. For example: customer(city) In GUIDE, if the structure is the first one you named, you can just enter the field name alone: city Related topics: define field field 'field description' description FIELD NAMES NAMES Field names When you refer to a field, you can specify a field name without the structure, unless the name is ambiguous. The first structure that has a field with the name will be used. Examples: open customer open vendor print city GUIDE will print the CITY from the customer file. To refer to the CITY field in VENDOR, use the structure name, followed by the field name within parentheses: print vendor(city) Related topics: expressions open 'show fields' 'show fields' FIELD POSITION POSITION Starting Position The starting position is the position in the record at which the field starts. Positions are numbered sequentially. Example: ID CONTACT 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 +---------+------------------------------------------ |5 5 2 9 4|A n d e r s o n , C a r l +---------+------------------------------------------ In this example, the ID field starts at position 1 and ends at position 5. The CONTACT field starts at position 6. Fields generally follow one right after another. Therefore the first position of a new field is usually one more than the last position used. For a new field, SETUP automatically defaults to the next sequential position. Related topics: define field 'field data type' 'data type' 'field length' length FIELD PRINT MASK MASK Print Mask A print mask indicates the format for printing a field. The format for the print mask is the same as for PRINT USING, and for the MASK option in GUIDE. Related topics: define field 'field heading' heading 'format characters' 'field screen mask' FIELD PROMPT PROMPT Prompt The field prompt is used when you enter data for a field. For example, if the prompt for the field FIRST is 'First name', a program can prompt the user: "First name? " A prompt can be up to 30 characters long. For a new field, the default prompt is the description entered. Related topics: define field 'field length' length 'field heading' heading FIELD SCREEN MASK MASK Screen Mask A screen mask indicates a format for entering data into a field. The screen mask should be left blank for the time being. Related topics: define field 'field print mask' 'print mask' 'field help text' 'help text' FORMAT CHARACTERS CHARACTERS Format Characters For a complete list of formatting characters, see the INTOUCH GUIDE TO THE LANGUAGE. # Print one character from the field @ Print one character from the field without translating . Decimal place , Comma, for numbers $ Float a dollar sign * Fill on left with asterisks % Fill on left with zeros Related topics: commands print 'print mask' mask GETTING STARTED STARTED To produce a report with GUIDE, use these steps: 1. Name the data structure you want to use Example: open customer 2. Name the fields you want to print Example: print custnbr, name, contact print phone Separate multiple fields on one line with commas. 3. Type GO to start the report. When GUIDE finishes producing the report, it prints a menu asking where to print the report. Enter SCR to print the report at your terminal. Then type EXIT to exit. Related topics: open print go GO GO GO - Produce the report Format: GO After you have entered all the other commands to set up a report, enter the command GO to start producing the report. GUIDE takes a template program and inserts INTOUCH code into it to produce a customized report, according to the commands you gave. GUIDE then runs the program, which displays statistics as it runs. After the program produces the report, you can print the report at your screen, through a printer port, or on the system printer. After you print the report, GUIDE redisplays the mock-up of the report, and your commands are as you left them. You can now save your report, modify it by typing EDIT, or type NEW to start a new report. Related topics: save edit new HEADING HEADING Heading The heading is used as a column heading on reports. The heading can be up to 30 characters long. For a new field, the default heading is the description. Some utilities, such as GUIDE, split headings into separate lines at commas. For example, 'Line,Item,No' becomes: Line Item No If the heading is blank, then the column underlines will be suppressed. To make a column heading blank, enter heading "". For example, 'Print name heading ""' Related topics: define 'field prompt' prompt 'field print mask' 'print mask' HELP HELP To get help on a GUIDE command, enter the name of the command. For a summary of the commands, see the topic Commands. Related topics: commands 'getting started' 'getting started' HELP_TOPIC HELP_TOPIC This help system allows you to receive help on any input items that you may enter. When you press the HELP key or type HELP at any prompt, an initial screen of help information is displayed. The help information explains the current topic and gives the names of any related topics that might be helpful to you. After reading this information, you can enter the name of one of the related topics or any other topic in which you might be interested. You only need to enter as much of the help topic name as is necessary to distinguish it from all other help topics within the help system. If your response is ambiguous, the help system will show you the possible topics and let you select the proper one. To be shown a menu of all topics, type a * at the "Help topic" prompt. Help topic? * To exit the help system, press the RETURN key. IF IF The IF statement allows the user to create conditional statement for use with LET statements. Examples: if account = 'CASH' then let amt = amt + trx_amt if account = 'CASH' then let desc$ = 'Cash Account' else let desc$ = '' endif Related Topics: let condition INCLUDE INCLUDE INCLUDE - Include records Format: INCLUDE expression INCLUDE FOUND structure INCLUDE keyfield = value1 TO value2 INCLUDE PARTIAL expression This command indicates which records to include in the report. Examples: include customer(balance) > 50 include customer(days_past_due) > 30 include invnbr = 1000 to 2000 include partial zip_code = "921" Related topics: exclude 'include found' found 'include keyfield' keyfield sort INCLUDE FOUND FOUND INCLUDE FOUND -- Include records only if found in structure given Format: INCLUDE FOUND structure INCLUDE FOUND includes a record from the first structure named only if the key is found in the structure given. Example: include found customer Related topics: include exclude INCLUDE KEYFIELD KEYFIELD INCLUDE keyfield -- Include records within a range of keys Format: INCLUDE keyfield = low-value TO high-value keyfield A field which is a key in the first structure named low-value Low range of values wanted high-value High range of values wanted The INCLUDE command with the keyfield option allows you to select records within a range of values. Example: include invnbr = 1000 to 2000 If you use this command, it must be the first INCLUDE or EXCLUDE statement given. Related topics: include INPUT INPUT INPUT - Input data from the user for use in producing a report. The input command allows the developer of the report to prompt the user for information necessary in processing the report. Any valid INTOUCH input statement can be entered. When the report is executed, the user will be prompted for all input statements entered. The data is available for use in INCLUDE, EXCLUDE and PRINT statements. In addition, a user-written validation routine can be specified. Please refer to the SET INPUT ROUTINE topic for further information about validation routines. The input statements are processed in the order that they are entered to GUIDE. The user is given BACK and EXIT capabilities from all inputs. The developer can enter a message to be displayed during each input statement to assist the user. If the SET PROCEED option is set to TRUE, the user will be asked a Proceed (Y/N) question before the report is produced. If the SET REPROMPT option is set to TRUE, the user will be reprompted for all inputs when finished displaying the report. Format: INPUT "Enter the account to print" : acct$ INPUT at 3, 10, valid "number", prompt "Account number: " : acct$ Related topics: set 'set input message' input_msg 'set input routine' input_routine 'set proceed' input_proceed 'set reprompt' input_reprompt %include LET LET LET - Assign a value to a variable Format: LET varname = expression varname Name of a variable expression Any INTOUCH expression With the LET statement, you can assign a value to a variable, so that you can use it later on for printing, calculations, etc. A variable can be valuable for doing intermediate calcuations, where you want to print out only the final result. Example: let balance = balance + amount Related topics: expressions variable LIST LIST LIST - Print fields. See PRINT. Related topics: MAKE MAKE MAKE - Select the type of output that GUIDE will produce The make command allows the user to select the output type that will be produced. Format: MAKE a REPORT (default) MAKE an EXPORT file MAKE an EXPORT STRUCTURE Make a report creates a standard report that can be printed to either the terminal or to one of the system printers. GUIDE can export two types of files. The command "MAKE AN EXPORT FILE" creates a comma seperated output file that is suitable for importing into spreadsheets or databases. The command "MAKE AN EXPORT STRUCTURE" create and INTOUCH structure. The datafile for this structure will be a standard RMS sequential file. Each field that is "printed" will be placed into the data record created The user can switch between output types by simple entering another MAKE command. related topics: export export_structure print NEW NEW NEW - Start a new report Format: NEW Guide clears memory to prepare for a new report. Be sure to save any previous report format first. Related topics: append old open print save OLD OLD OLD - Recall a previously saved series of commands Format: OLD filespec filespec Name under which the commands were saved. This name can contain any VMS file specification, including device, directory, logical, etc. The default extension is .GUIDE. This command recalls a series of commands that were previously saved. Examples: old invoice_report old dua2:[ar.reports]cust_list Related topics: append new output program OPEN OPEN OPEN - Open a structure to use in a report Format: OPEN [str-syn NAME] filespec [datafile data_file_spec] [systemset "set-name"] [routine routine-name] OPEN structure-synonym-in-GUIDE_NAMES str-syn Synonym or nickname to use when referring to the structure within GUIDE. If you do not indicate a synonym, you will use the structure's filename to refer to the structure. filespec Structure to open. The structure name can be any VMS file specification. datafile The name of an alternate datafile to be used when opening the structure. systemset For DBMS structures only. This is the name of a system owned set to be used when accessing the records of the primary (first) structure. routine The name of a user-written routine to run each time we get a record from the file. The routine must exist in an %INCLUDEd file. structure-synonym-in-GUIDE_NAMES Synonym using the translation table in TTI_RUN:GUIDE_NAMES. Since this feature is being phased out, we recommend that you use logicals instead. The OPEN command opens a structure that you are using in your report. When you open a structure, you can also enter a synonym, so that you can use a different name when you refer to the structure later on. For example, for EMPLOYEE you could use the shorter name EMP. Examples: open client open storage:[intouch]vendor open det name detail open employee systemset "all_parts" open cust name ar_data:customer routine translate_customer_flags Related topics: commands 'field names' 'field names' 'primary-structure' 'primary structure' 'open reserved-words' 'reserved words' '%include' OPEN RESERVED-WORDS RESERVED-WORDS Reserved Words for Open Structures Certain words are reserved for commands. The following words cannot be used to name a structure: list relate with totals Related topics: open 'show open' OUTPUT OUTPUT OUTPUT - Name the output listing file Format: OUTPUT output-filespec [UNIQUE] output-filespec Name of the output listing file. This name can be any VMS file specification. The default extension is .LIS. The output listing file is the actual report produced. By default, GUIDE creates a temporary report listing file with the name GUIDE_PRINT.TMP in your SYS$SCRATCH directory. If you want to put the output somewhere else, you can specify a listing file with the OUTPUT command. The unique qualifier ensures that the output filename created will be unique. Example: output payroll:alpha.lis output payroll:alpha.lis unique Related topics: program save OUTPUT-COMMANDS OUTPUT-COMMANDS Output commands APPEND BREAK EXCLUDE GO INCLUDE KEY LET NEW OLD OPEN OUTPUT PRINT PROGRAM RELATE SET SAVE SORT TITLE Related topics: commands screen-commands PAGE HEADING HEADING For a page heading, use the TITLE command. Related topics: title PERCENT PERCENT PERCENT - Print a percentage Format: PERCENT expression OF [TOTAL] expression The PERCENT option gives you a percentage of an amount. The option is often used together with the TOTAL option to get a percentage of a total amount. For example, you can print the percentage that a current record is of all the records with the example below. Example: print percent amount of total amount Related topics: print total PRIMARY-STRUCTURE PRIMARY-STRUCTURE Primary Structure The first structure opened is considered the PRIMARY STRUCTURE. All INCLUDEs, EXCLUDEs, and SORTs are done with the primary structure. Other structures are used only as a cross-reference lookup. You can have nine structures open. Related topics: exclude include open 'show structure' 'show open' PRINT PRINT PRINT -- Print fields and other data Format: PRINT expression [, ...] The PRINT command prints one or more columns on the report. Separate multiple columns with commas. Examples: print prodnbr print prodnbr, desc, cost Each print column can have one or more of the following options. See the related topic on the option for more information. GROUP break-level HEADING "heading-expr-1" ["heading-expr-2" ["heading-expr-3"]] LENGTH column-length MASK "edit-mask" POS[ITION] {column-position | + preceding-spaces | = column-nbr} [WITH] TOTALS [= totals-expression] FIELD field name to be used for a field when exporting to a structure The following reserved variables can be printed. See the related topic on the variable for more information. COUNT count of records in a group. GROUPCOUNT count of the number of times a break occured. To print an element of an array, specify the element number using a "#" character. For example: print customer(address#1) Related topics: break cume 'cumulative totals' expression percent 'print count' count 'print group' group 'print groupcount' groupcount 'print heading' 'heading' 'print length' 'length' 'print mask' 'mask' 'print field' field 'print position' position 'print totals' totals 'print totals-expression' 'totals expression' total PRINT COUNT COUNT Print Count - print the count of the records occuring in a group. The count variable counts the number of records that have been processed for each level break. The command PRINT COUNT causes this value to be printed as a column on the report. All of the print options can be used with the count variable. Example: PRINT COUNT PRINT COUNT WITH TOTALS MASK #,### Related Topics: print 'print groupcount' groupcount PRINT FIELD FIELD FIELD - Associate a field name to the column when exporting to a structure The FIELD qualifier is used to override the default field name assigned to a print expression when using the MAKE AN EXPORT STRUCTURE command. By default, GUIDE will create a field name that consist of "COL" plus a sequence number. The user can override this name using the FIELD qualifier. Example: print trx_amount FIELD trx_amount Related Topics: export make print PRINT GROUP GROUP GROUP -- Print only at a level break Format: GROUP break-level break-level Number of the level break to print at. The group option tells GUIDE to print only at a level break. You indicate which break to print at with the break-level number. Example: sort by customer(number) break on customer(number) print customer(name) group 1 Related topics: break print 'print totals' totals PRINT GROUPCOUNT GROUPCOUNT Print Groupcount - count the number of breaks for each group. Groupcount counts the number of times that a break has occured for each level break. This allows the user to respond to a query such as: How many different clients have used each service that we offer. Example: Open service_log sort by service sort by client break on service break on client print service print groupcount Related Topics: sort break print 'print count' count PRINT HEADING HEADING HEADING -- Column heading Format: [HEADING "heading-expr-1" ["heading-expr-2" ["heading-expr-3"]]] You can set up column headings with the HEADING option. There can be up to three lines of column headings. Indicate each heading with a separate quoted string. If you do not specify column headings, GUIDE takes headings for a field from the definition file. Example: print prodnbr heading 'Standard' 'Product' 'Number' This produces a column heading like this: Standard Product Number ----------- Related topics: 'print' 'print'