Reusing Sort Criteria in New Reports The reason to save sort criteria in a SORT template is so that you can reuse your sort criteria in a new report from the same file. To reuse a SORT template as the sort criteria in a new report, at the “SORT BY:” prompt in the new report, enter a left bracket ( [ ) plus the template name: Figure : Print—Reusing a Sort Template OUTPUT FROM WHAT FILE: NEW PERSON// <Enter> SORT BY: NAME// [ADDRESS LIST <Enter> (Dec 08, 1995@07:53) User #34 File #200 WANT TO EDIT ‘ADDRESS LIST’ TEMPLATE? NO// <Enter> FIRST PRINT FIELD: Choosing Print Fields Specifying Fields to Print After you have specified the order in which the output should occur, you are asked to list the fields you want displayed for each file entry. In the simplest case, fields are identified by their label. If you enter a single question mark (?) at the prompt, a list of all the fields in the file is displayed. If you enter the name of a Multiple, you are asked for the subfields you want printed. A subfield must be specified even if the Multiple has only one subfield. To print all fields in the file, enter ALL (uppercase) at the “FIRST PRINT FIELD:” prompt. You are then prompted: Figure : Print—Confirmation Message to Print All Fields Do you mean ALL the fields in the file? NO// Enter YES to indicate all fields; otherwise, the file is searched for field labels beginning with the letters “ALL”. NOTE: Fields from other files can also be printed using extended pointers. This technique is described in the “Using Computed Expressions in COMPUTED Fields” section in the “Computed Expressions” section in the VA FileMan Advanced User Manual. You can also enter other computed expressions, which are also described in that section. Print Qualifier Reference VA FileMan’s print capabilities provide many ways to format a report. If you do not specify any formatting controls, a format is constructed automatically. The width of each field’s print area is computed using information from the field’s definition. The default width is the larger of the following in the print dialogue: Maximum number of characters allowed for the field.
COMPUTED Fields and Record Numbers, 28 Template, 70 CAPTIONED PRINT Template, 28, 70 Caret Exiting at Prompts, 60, 61 Inserting Multiple-type Print Fields, 27 Jumping to another Field, 60 ScreenMan, 92 Characters Lost, Avoiding Screen Editor, 111 Choose Your Own Device, 9 Print Fields, 8, 21 Word-processing Editors, 101 Choosing a Preferred Editor, 101 Clipboard Browser, 48 Column Format for VA FileMan Prints, 11 Commands Available with the Line Editor, 116 ScreenMan Command Line Options:, 93 Compound Key, 59 COMPUTED DATA TYPE Fields, 70 Computed Fields, 7 COMPUTED Fields and Record Numbers in CAPTIONED OUTPUT, 28 Conditions Combining in a Search, 37 Entering in a Search, 34 Tests in a Search, 35 Conventions Documentation, xix Creating PRINT Templates, 26 SEARCH Templates, 41 SORT Templates, 7, 20 Criteria, Saving in PRINT Templates, 26 SEARCH Templates, 41 SORT Templates, 20 Cursor Movement (Navigation Keystrokes) Browser, 47 Screen Editor, 105 ScreenMan, 91, 94 Custom Footers, 32 Custom Headings and Footers, 31 Cutting and Pasting Screen Editor, 107 D Data Dictionary Data Dictionary Utilities Menu, xxi Listings, xxi Data Entry Session (Typical Example), 62 Data Types of Fields, 63 DATE/TIME, 64 FREE TEXT, 68 NUMERIC, 66 SET OF CODES, 67 WORD-PROCESSING, 68 DATA TYPEs of Fields COMPUTED, 70 Multiples (Subfiles), 77 POINTER TO A FILE, 71
Subfiles (Multiples), 77 VARIABLE-POINTER, 72 DATA TYPES of Fields BOOLEAN, 74 FT DATE, 76 FT POINTER, 76 LABEL REFERENCE, 74 RATIO, 76 TIME, 75 UNIVERSAL TIME, 75 YEAR, 75 Database and Files, 2 DATE/TIME Data Type Fields, 64 Dates Abbreviations, 65 Acceptable Formats, 64 DDBROWSER Option, 45, 51 Default Responses, 55 Default Responses (Longer), 56 Delete Line(s) Option, 118 Deleting A Field’s Value with the at-sign, 59 A Multiple (Subfile) Entry in ScreenMan, 98 From Multiples, 85 How to Delete a Record, 80 Lines of Text in the Line Editor, 118 Records, 78 Screen Editor, 108 ScreenMan, 94 Details ScreenMan, 100 Search, 40 Devices, Choose Your Own, 9 DI DDU Menu, xxi DIEDIT Option, 82, 86 Differences from Scrolling Mode Editing ScreenMan, 89 DIINQUIRE Option, 5, 6, 10 DILIST Option, xxi DIOTHER Menu, 51 DIPRINT Option, 10 Disclaimers, xix Software, xviii DISEARCH Option, 34 DIUSER Menu, 51 Documentation Conventions, xix Symbols, xix Documentation Navigation, xx Duplicates Adding a Duplicate Record, 79 Duplicate-Named Entry, 84 E Edit a Line (Replace __ With __) option, 113 Edit Fields How to do it in ScreenMan, 94 Edit Lines with M Commands Line Editor, 120 Edit User Characteristics Option, 101 Editing ScreenMan, 94 Editor Change Option, 120
Editors Change (Switch) Editors Line Editor, 120 Choice of Word-processing Editors, 101 Choosing a Preferred Editor, 101 Line Editor, 112 Replace...With, 56, 63, 114, 115 Screen Editor, 102 Select Your Preferred Editor, 101 Switch (Change) Editors Line Editor, 120 Switching to another Editor While Editing, 102 WORD-PROCESSING Fields, 68 Zoom Editor in ScreenMan, 95 Edits Edit User Characteristics Option, 101 How to File in ScreenMan, 100 Ellipsis, 114 Enter Key (<Enter>), 52 Enter or Edit File Entries Option, 82, 86 Entering Commands in the Screen Editor, 104 Text in the Line Editor, 112 Screen Editor, 104 Example Data Entry Session (Typical), 62 Exiting Screen Editor, 106 ScreenMan, 92 From a Subpage:, 98 With the Caret, 60, 61 External vs. Internal Field Values Search Conditions, 42 SET OF CODES, 67 F Features Browser, 47 Line Editor Advanced Features, 118 Other Features of the Browser, 50 Other Print Features, 29 Search, 40 Field Prompts Special Responses to, 59 Fields .01 Field, 78 Choosing Fields to Print, 21 Data Types, 63 DATE/TIME, 64 FREE TEXT, 68 NUMERIC, 66 SET OF CODES, 67 WORD-PROCESSING, 68 DATA TYPEs BOOLEAN, 74 COMPUTED, 70 FT DATE, 76 FT POINTER, 76 LABEL REFERENCE, 74 Multiples (Subfiles), 77 POINTER TO A FILE, 71 RATIO, 76 Subfiles (Multiples), 77 TIME, 75
UNIVERSAL TIME, 75 VARIABLE-POINTER, 72 YEAR, 75 Deleting a Field’s Value, 59 Jumping to another Field, 60 Mandatory (Required), 61 Required (Mandatory), 61 Fields, Records, and Files, 1 File Access LAYGO, 4 File Edits How to do it in ScreenMan, 100 File Transfer from Foreign CPU Option, 118 Line Editor, 118 FileMan Prompts, 51 What is it?, xvi Files KERNEL SYSTEM PARAMETERS (#8989.3), 29 PATIENT (#2), 71, 72 PRINT TEMPLATE (#.4), 26 PROVIDER, 72 SORT TEMPLATE (#.401), 20, 40, 41 STATE (#5), 71, 72 Files and the Database, 2 Files, Save as Text Screen Editor, 110 Finding Text Screen Editor, 106 Footers Customized, 31, 32 Forcing Creation of a PRINT Template, 26 SORT Template, 21 Format Output in a Search, 39 Paragraphs in the Screen Editor, 107 FREE TEXT Data Type Fields, 68 FT DATE DATA TYPE Fields, 76 FT POINTER DATA TYPE Fields, 76 G Getting Online Help at Any Prompt, 54 Glossary, 123 H Headings Customized, 31 Help At Prompts, xxi Getting Online Help at Any Prompt, 54 Online, xxi Question Marks, xxi Home Pages Adobe Website, xxii VA Software Document Library (VDL) Website, xxii How to Add a Record, 78 Add a Record at a POINTER TO A FILE Field, 83 Delete a Record, 80 Edit Fields ScreenMan, 94 Enter Text in the Line Editor, 112 Exit the Screen Editor When PF Keys Not Working, 110
Recognizing, 112 Revising Text, 113 Shortcuts, 113 Switch (Change) Editors, 120 Text-Terminator-String Change Option, 119 Transfer Lines From Another Document Option, 120 Transfer Text (from another Field), 120 Uploading Text with Blank Lines, 119 Y-Programmer Edit Option, 120 List a Range of Lines Option, 116 List File Attributes Option, xxi List of Choices Prompts, 57 List the Message (Line Editor), 116 Long Fields ScreenMan, 95 Longer Default Responses, 56 M Mandatory (Required) Fields, 61 Manuals In HTML, xviii Menus Data Dictionary Utilities, xxi DI DDU, xxi DIOTHER, 51 DIUSER, 51 Other Options, 51 User’s Toolbox, 101 VA FileMan, 51 XUSERTOOLS, 101 Modes Screen Editor, 109 ScreenMan, 95 Scrolling Mode vs. Screen Mode, 4 Multiple Copies of a Print, 29 Multiples (Subfiles) Adding a New Entry in ScreenMan, 98 Adding and Deleting from, 85 DATA TYPE Fields, 77 DATA TYPEs Fields Adding and Deleting from, 85 Deleting an Entry in ScreenMan, 98 In Repeating Blocks in ScreenMan, 99 Linked to ”Popup” Subpages in ScreenMan, 97 ScreenMan, 97 Searching for, 42 N Navigate between Fields How to do it in ScreenMan, 91 Pages How to do it in ScreenMan, 92 Navigation Keystrokes Browser, 47 Screen Editor, 105 ScreenMan, 91 Navigational Keys for Repeating Blocks ScreenMan, 100 NULL Fields in Your Sort, 15 Numbers Canonic Numbers and Non-Canonic Strings, 13
NUMERIC Data Type Fields, 66 O Online Documentation, xxi Technical Information, How to Obtain, xxi Online Help Browser, 49 Operators for Combining Search Conditions, 37 Options Add Lines to End of Text, 117 Browser, 45, 51 Data Dictionary Utilities, xxi DDBROWSER, 45, 51 Delete Line(s), 118 DI DDU, xxi DIEDIT, 82, 86 DIINQUIRE, 5, 6, 10 DILIST, xxi DIOTHER, 51 DIPRINT, 10 DISEARCH, 34 DIUSER, 51 Edit a Line (Replace __ With __), 113 Edit User Characteristics, 101 Editor Change, 120 Enter or Edit File Entries, 82, 86 File Transfer from Foreign CPU, 118 Inquire to File Entries, 5, 6, 10 Insert Lines after an Existing Line, 117 Join Line to the One Following, 117 List a Range of Lines, 116 List File Attributes, xxi Other Options, 51 Print File Entries, 10 Search File Entries, 34 Text-Terminator-String Change, 119 Transfer Lines From Another Document, 120 User’s Toolbox, 101 VA FileMan, 51 XUSEREDITSELF, 101 XUSERTOOLS, 101 Y-Programmer Edit, 120 Order When Sorting, 13 Orientation, xvii Other Features Browser, 50 Print, 29 Other Options Menu, 51 Output Format in a Search, 39 P Partial Responses, 55 Pasting and Cutting Screen Editor, 107 Pasting and Uploading Screen Editor, 110 PATIENT (#2)File, 72 PATIENT (#2) File, 71, 72 Personal Computers and the Screen Editor, 110 PF Keys Not Working, How to Exit in the Screen Editor, 110
POINTER TO A FILE DATA TYPE Fields, 71 PREFERRED EDITOR Prompt, 102 Print, 10 Capabilities, 10 CAPTIONED PRINT Template, 28 Choosing Fields to Print, 21 Custom Footers, 32 Custom Headings and Footers, 31 Forcing Creation of a PRINT Template, 26 Including NULL Fields in Your Sort, 15 Inserting Multiple-type Print Fields, 27 Multiple Copies, 29 Other Features, 29 PRINT FIELD Prompts, 22 Qualifiers, 22 Report Headings, 29 Reports from Files, How to, 10 Saving Criteria in PRINT Templates, 26 Selecting Entries All Entries with the Same Value for One Field to Print, 14 For Printing, 14 Other Ways to Print, 14 SORT BY Fields, 31 Prompts, 17 Specifying, 12 Sorting, 12 Order, 13 Print Sort Criteria in the Heading or the Footer, 33 Qualifiers, 17 Specifying Fields to Print, 21 Specifying SORT BY Fields, 12 Standard Column Format, 11 Statistics Only, 29 Suppressing Report Headings (and Page Feeds), 31 Templates CAPTIONED PRINT, 28 Forcing the Creation of, 26 PRINT, 26 Using and Editing, 27 Using and Editing PRINT Templates, 27 Print Fields, Choose Your Own, 8 Print File Entries Option, 10 Print Number of Matches Found, 42 PRINT TEMPLATE (#.4) File, 26 Programmer Edit Line Editor, 120 Prompts Default Responses, 55 Display Audit Trail, 7 Getting Online Help, 54 Include Computed Fields, 7 Incorrect Responses, 54 List of Choices, 57 Longer Default Responses, 56 Partial Responses, 55 PREFERRED EDITOR, 102 PRINT FIELD, 22 Replace... Prompt Shortcuts, 57 Replace...With, 114 Editor, 56 Shortcuts, 114, 115 Responding to, 53
Tests, 35 External vs. Internal Field Values in Search Conditions, 42 Format Output, 39 How to Search, 34 Internal vs. External Field Values in Search Conditions, 42 Multiples (Subfiles), 42 Operators for Combining Search Conditions, 37 Print Number of Matches Found, 42 Reusing Search Criteria, 41 Search Results in a Print, 41 Search Results in another Search, 41 Saving Criteria in SEARCH Templates, 41 Steps, 34 Combine Conditions, 37 Entering Conditions, 34 Format Output, 39 Subfiles (Multiples), 42 Templates, 40, 41 Creating, 41 Reusing Search Criteria, 41 Search Results in a Print, 41 Search Results in another Search, 41 Search File Entries Option, 34 Select Entries for Printing Sorting, 14 Select Your Preferred Editor, How to, 101 Selecting All Entries with the Same Value for One Field to Print, 14 Selecting Entries Other Ways to Print, 14 SET OF CODES Data Type Fields, 67 Settings Screen Editor, 109 Shortcuts Line Editor, 113 Replace... Prompt, 57 Replace...With Prompt, 114, 115 ScreenMan, 93 Similarities with Scrolling Mode Editing ScreenMan, 88 Software Disclaimer, xviii Sort Canonic Numbers and Non-Canonic Strings, 13 Forcing Creation of a SORT Template, 21 Including NULL Fields in Your Sort, 15 Non-Canonic Strings and Canonic Numbers, 13 Order Before Printing, 13 Qualifiers, 17 TXT, 13 Reusing Sort Criteria in New Reports, 21 Saving Criteria in SORT Templates, 20 Searching, 40 Select Entries for Printing, 14 SORT BY Fields Prompts, 17 Specifying, 12 Sorting Before Printing, 12 Specifying SORT BY Fields, 12 Templates, 7, 20
Forcing the Creation of, 21 Reusing Sort Criteria in New Reports, 21 SORT BY Fields, 31 SORT TEMPLATE (#.401) File, 20, 40, 41 Spacebar Recall, 61 Special Responses to Field Prompts, 59 Specifying Fields to Print, 21 Sort, 12 Specifying SORT BY Fields, 12 Standard Captioned Output, 7 Standard Column Format for VA FileMan Prints, 11 Standard Prompt Structure, 53 STATE (#5)File, 71 STATE (#5) File, 71, 72 Statistics Only in Printing, 29 Steps in Searching, 34 Subfields, 77 Subfiles (Multiples) Adding and Deleting from, 85 DATA TYPE Fields, 77 Adding and Deleting from, 85 Searching for, 42 Suppressing Report Headings (and Page Feeds), 31 Switching to another Editor While Editing, 102 Symbols Found in the Documentation, xix Screen Editor, 110 T TBOX, 101 Templates CAPTIONED OUTPUT, 70 CAPTIONED PRINT, 28, 70 PRINT, 26 Forcing the Creation of, 26 Using and Editing, 27 SEARCH, 40, 41 Reusing Search Criteria, 41 Search Results in a Print, 41 Search Results in another Search, 41 SORT, 7, 20 Forcing the Creation of, 21 Reusing Sort Criteria in New Reports, 21 Terminal Type Setting Screen Editor, 109 Text-Terminator-String Change Option, 119 Line Editor, 119 TIME DATA TYPE Fields, 75 Times Abbreviations, 66 Acceptable Formats, 65 Transfer Lines From Another Document Option, 120 Transfer Text (from another Field), 120 Troubleshooting Screen Editor, 109 ScreenMan, 101 TXT Sort Qualifier, 13