�STORE/RESTORE-HP/3000.MPEXL  1*� �������B5152AA  C602403/16/010000���?fS�+�U�E��iESCAPET         QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS�.�U�f�>w�HESCENVEL        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS�1�U�u�E��HESCPORT         QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS�4�U�s�M�HESCSPECT        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS�7�U���S���LLJRESET        QCPUB           AICS            MGR             AICS            MGR     AICS    `������(���H00000000000000000                            000000STORE  esc@,ll@;*v
�����������������k`fS�+�U�E�ii� ����DISC                             1ESCAPET         QCPUB           AICS                            MGR     AICS    �fS5���X�5���X�5��tX5���	�i	�Po�P�   5���	�AICS            ii                 QueryCalc Reports for Credit Unions                                               written by:  Mizzou Credit Union                                                     last update:  01/01/99                                                                                                                                     LASER PRINTER ESCAPE SEQUENCES                                               -------------------------------------                                                TESTED ON:  HP LaserJet 4M                                                                  HP LaserJet 5si                                                                 Lexmark Optra S2420                                                                                                                                                                                            This file contains important information on the following topics:               **********************************************************************          Report highlights                                                               Files included                                                                  Databases accessed                                                              Download instructions                                                           Restoring files to the HP3000                                                   Customizing the report for the credit union                                     General notes on escape sequences                                               Deciphering the escape sequences provided                                       Limited warranty on reports                                                                                                                                                                                                                     Report highlights                                                               **********************************************************************          This is not a QueryCalc report and these files are not needed for               printing QueryCalc reports.                                                                                                                                     This is a collection of 5 files.  The first 4 files contain escape              sequences that have been tested and used on HP LaserJet printers to             print Spectrum output to LaserJet printers.  The fifth file is a text           file that explains how the escape sequences are constructed.                                                                                                    Following is an example of using the escape sequences to print an income statement:                                                                                                                                                             `        General Ledger Statement of Income Report                                                                                                              ?HMGLSTI0                                                                       ^~Enter Report Date (MMDDYY)       _6 DATE  {123188}  [RPTDTE]                  ~~Enter Rpt Title _10 CHAR INCOME,EXPENSES,OPERATIONS,COMPARE {INCOME}           [RPTHED]                                                                       ~|Enter Net Gain/Income GL Account _10 CHAR {960200.00} [NETACT]                ~|Enter GL Account for % Calc      _10 CHAR {100000.00} [PERACT]                ~~Enter Compare Info_36 CHAR {MONTH 04-95 WITH MONTH 03-95} [COMTLT]            ~|Enter Option to Print GL Account Numbers _3 CHAR YES,NO {YES} [PRTOP          T]                                                                              ~|Enter Hold-File Search Date      _9 CHAR EFFECTIVE,ENTRY {ENTRY    }           [HFDT]                                                                         ~~ENTER NUMBER OF COPIES           _1 INT {1} [COPIES]                          ~|ENTER PRIMARY SORT OPTION  _6 CHAR BRANCH,REGION,NONE {NONE} [SORTO]                                                                                          ~|ENTER SELECT OPTION  _6 CHAR BRANCH,REGION,NONE {NONE} [SELECTO]              ~|ENTER SELECTIONS     _4 LINES {END}  [SELECTS]                                !JOB TMGLSTI1,[MGRUSER].[ACCNT][PWD],[DATAGRP][JOBPRI]                          !COMMENT ***********************************                                    !COMMENT ***  BUILD A BLANK REPORT FILE  ***                                    !COMMENT ***********************************                                    !PURGE RRINSTMT                                                                 !BUILD RRINSTMT;DEV=DISC;DISC=30000,32,1;REC=-136,20,F,ASCII;CCTL               !COMMENT *************************************                                  !COMMENT ***  COPY IN ESCAPE SEQUENCE FOR  ***                                  !COMMENT ***    LJ LANDSCAPE CONDENSED     ***                                  !COMMENT *************************************                                  !FILE WORK=RRINSTMT,OLD;ACC=APPEND                                              !FCOPY FROM=ESCSPECT.QCPUB.CU1;TO=*WORK;CCTL                                    !COMMENT *************************************                                  !COMMENT ***  PRODUCE AN INCOME STATEMENT  ***                                  !COMMENT *************************************                                  !FILE FTN10=RRINSTMT,OLD;ACC=APPEND;CCTL                                        !RUN PGLSTMIN.[PGMSGROUP];LIB=P                                                 [RPTDTE]                                                                        [RPTHED] [COMTLT]                                                               [NETACT]                                                                        [PERACT]                                                                        [PRTOPT]                                                                        [HFDT]                                                                          [SORTO]                                                                         [SELECTO]                                                                       [SELECTS]                                                                       !COMMENT *************************************                                  !COMMENT ***  COPY IN ESCAPE SEQUENCE FOR  ***                                  !COMMENT ***           LJ RESET            ***                                  !COMMENT *************************************                                  !FCOPY FROM=LLJRESET.QCPUB.CU1;TO=*WORK                                         !COMMENT *****************************************************                  !COMMENT ***  COPY WORKFILE TO ACCOUNTING's LASER PRINTER  ***                  !COMMENT *****************************************************                  !FILE LASER;DEV=316,,[COPIES];REC=-136,20,F,ASCII;CCTL                          !FCOPY FROM=RRINSTMT;TO=*LASER;CCTL                                             !PURGE RRINSTMT                                                                 !TELLOP  ****************************************                               !TELLOP  ***  TMGLSTI1 HAS FINISHED FOR CU1  ***                                !TELLOP  ****************************************                               !SET STDLIST=DELETE                                                             !EOJ                                                                                                                                                                                                                                                                                                                            Files included                                                                  **********************************************************************           1) escenvel - escape sequence for envelopes                                     2) escspect - escape sequence for printing landscape                            3) escport  - escape sequence for printing portrait                             4) lljreset - escape sequence for resetting printer                             5) Readme   - this text file of instructions                                                                                                                                                                                                   Databases accessed                                                              **********************************************************************          This report uses data from the following databases:                                                                                                                     N/A                                                                                                                                                                                                                                     Download instructions                                                           **********************************************************************          Although downloading reports from the web site is quite simple, you             may wish to print these instructions before proceeding.  The procedure          outlined below requires the use of: (i) a relatively recent version of          the Reflection terminal emulator and (ii) either Netscape Navigator             3.0 (or greater) or Microsoft Internet Explorer 3.0 (or greater),               running on any version of Windows (3.x, 95, or NT). If you're missing           any of these pieces, the downloading procedure unfortunately will not           work.                                                                                                                                                                Step 1.                                                                         -------                                                                         Click on the desired download link. Store the self-extracting                   file anywhere you wish on your PC. Its residency on your PC                     will only be temporary. At the conclusion of the downloading                    process, after the files have been successfully transferred to                  your HP3000, this file will be deleted.                                                                                                                         Step 2.                                                                         -------                                                                         Once the file has been downloaded, double click on the newly                    downloaded file. When you press the UnZip button, the file will                 unzip itself and automatically build an AICS directory (folder)                 on the C: drive, with a subdirectory (subfolder) labeled                        Reports.                                                                                                                                                        Step 3.                                                                         -------                                                                         You will now find files in the Reports subdirectory.  The files                 include a Readme.txt file, the report and any attendant macros,                 jobs and ancillary files (see above).  These files are stored                   in Reflection's WRQ protocol (LABEL mode) and must be                           transferred back onto your HP3000 in that format. The particular                version of Reflection that was used to originally upload these                  files was 5.21. It would probably be best to use a reasonably                   similar version.                                                                                                                                                Step 4.                                                                         -------                                                                         Using Reflection, restore the files to your HP3000 using the                    procedure outlined below.                                                                                                                                       Step 5.                                                                         -------                                                                         Once the transfer is complete, follow the instructions below to                 setup the report for your credit union.                                                                                                                         Step 6.                                                                         -------                                                                         Once you are satisfied that the report is working, you may                      delete the self-extracting download file as well as the Reports                 subdirectory and its files from your PC's file directory.                                                                                                       Step 8.                                                                         -------                                                                         Congratulations on a successful download. We sincerely hope you                 will find your new QueryCalc report useful!                                                                                                                                                                                                Restoring files to the HP3000                                                   **********************************************************************           1)  Using Reflection, sign onto your HP3000 to the group and account                the files are to be stored to.  You may use any group or account                you choose.  However, you will need to adjust the FCOPY statement               in your job to reflect the group and account where the files were               restored.                                                                                                                                                   2)  Using Reflection, transfer the files, using LABEL mode transfer.                                                                                            3)  Once the transfer is complete, you may delete the files and                     directories from your PC hard drive.                                                                                                                                                                                                       Customizing the report for the credit union                                     **********************************************************************          There are no additional modifications that need to be made to use               these files.  However, you will need to modify your jobs in order to            print to a laser printer.                                                                                                                                       The basic steps for modifying a report's output in the example above            were:                                                                                                                                                            1)  Insert lines to build a blank report file.  The name of the                     the report file is up to you.  The size must be sufficient to                   hold the output.                                                                                                                                            2)  Copy a file containing the correct escape sequences into the                    report file to change the printer's settings. These are the first               commands that will be sent to the printer.                                                                                                                  3)  In the report, change the output file to the name you assigned                  to the report file.  Insure that the output appends to the end                  of the report file instead of replacing it.  In the example                     above, the FTN10 line demonstrates.                                                                                                                         4)  After the report has completed, it is important to "Reset" the                  printer so that output going to this printer after this report                  does not retain the same settings.                                                                                                                          5)  The report file is now built.  It can be sent to the printer by                 using the FCOPY command and copying the file to a laser printer.                                                                                                                                                                                                                                                           General Notes on Escape Sequences                                               **********************************************************************           1)  Commands starting with the same characters can be concatenated                  together.                                                                                                                                                   2)  Common starting characters are placed at the front (e.g. [ESC]&l)                                                                                           3)  Terminating characters are lower case in the middle of the string                                                                                           4)  Last character in the new string must be capitalized.                                                                                                                                                                                                                                                                      Deciphering escape sequences                                                    **********************************************************************                                                                                          ESCSPECT.QCPUB.CU1                                                              ------------------                                                                                                                                                [ESC]&l2a1o2e59f8D[ESC]&a5l176M[ESC](8U[ESC](s0p13.67h0s3b4102T                                                                                                                                                                                  Page Control Command Group                                                        [ESC]&l2a1o2e59f8D                                                              [ESC]&l2A               Set Page Size to Letter                                 [ESC]&l1O               Set Page Orientation to Landscape                       [ESC]&l2E               Set Top Margin = 2 lines                                [ESC]&l59F              Set Text Length = 59 lines                              [ESC]&l8D               Set Line Spacing to 8 lines/inch                                                                                                      Page Control Command Group                                                        [ESC]&a5l176M                                                                   [ESC]&a5L               Set Left Margin = 5 Columns                             [ESC]&a176M             Set Right Margin = 176 Columns                                                                                                        Font Selection Command Group                                                      [ESC](8U                                                                        [ESC](8U                Set Primary Symbol Set = Roman 8                                                                                                      Font Selection Command Group                                                      [ESC](s0P               Set Primary spacing = Fixed                             [ESC](s13.67H           Set Primary pitch = 13.67 characters/inch               [ESC](s0S               Set Primary style = Upright (solid)                     [ESC](s3B               Set font stroke weight = bold                           [ESC](s4102T            Set typeface family = Letter Gothic                                                                                                                                                                                                                                                                ESCPORT.QCPUB.CU1                                                               -----------------                                                                                                                                                 [ESC]&l2a0o2e59f8D[ESC]&a5l80M[ESC](8U[ESC](s0p13.67h0s3b4102T                                                                                                                                                                                   Page Control Command Group                                                        [ESC]&l2a0o2e59f8D                                                              [ESC]&l2A               Set Page Size to Letter                                 [ESC]&l0O               Set Page Orientation to Portrait                        [ESC]&l2E               Set Top Margin = 2 lines                                [ESC]&l59F              Set Text Length = 59 lines                              [ESC]&l8D               Set Line Spacing to 8 lines/inch                                                                                                      Page Control Command Group                                                        [ESC]&a5l80M                                                                    [ESC]&a5L               Set Left Margin = 5 Columns                             [ESC]&a80M              Set Right Margin = 80 Columns                                                                                                         Font Selection Command Group                                                      [ESC](8U                                                                        [ESC](8U                Set Primary Symbol Set = Roman 8                                                                                                      Font Selection Command Group                                                      [ESC](s0P               Set Primary spacing = Fixed                             [ESC](s13.67H           Set Primary pitch = 13.67 characters/inch               [ESC](s0S               Set Primary style = Upright (solid)                     [ESC](s3B               Set font stroke weight = bold                           [ESC](s4102T            Set typeface family = Letter Gothic                                                                                                                                                                                                                                                                ESCENVEL.QCPUB.CU1                                                              ------------------                                                                                                                                                [ESC]&l3h                                                                                                                                                                                                                                        Page Control Command Group                                                        [ESC]&l3H                                                                       [ESC]&l3H               Set Paper source to Manual envelope feed                                                                                                                                                                           LLJRESET.QCPUB.CU1                                                              ------------------                                                                                                                                                [ESC]E                                                                                                                                                                                                                                           Job Control Command Group                                                         [ESC]E                                                                          [ESC]E                  Reset Printer                                                                                                                                                                                                                                                                                                                                                                      Limited Warranty on Reports                                                     **********************************************************************          *  The reports are distributed "AS IS".  No warranties are made or                 provided by any parties.                                                                                                                                     *  The reports are copyrighted.  Sale or redistribution of the                     reports is strictly prohibited.                                                                                                                              *  The download and/or use of these reports indicates acceptance of                the terms set forth.                                                                                                                                         k`���������fS�.�U�f�>wHH� ����DISC                             1ESCENVEL        QCPUB           AICS                            MGR     AICS    �fS5��M�5��M�5��N2�5��N2�HHH�  5��N2�AICS            HH&l3H                                                                   ����������fS�1�U�u�E�HH� ����DISC                             1ESCPORT         QCPUB           AICS                            MGR     AICS    �fS5��j;%5��j;%5��j��5��j��HHH�  5��j��AICS            HHA&l2a0o2e59f8D&a5l80M(8U(s0p13.67h0s3b4102T                         ����������fS�4�U�s�MHH� ����DISC                             1ESCSPECT        QCPUB           AICS                            MGR     AICS    �fS5����D5����D5����5����HHH�  5����AICS            HHA&l2a1o2e59f8D&a5l176M(8U(s0p13.67h0s3b4102T                        ����������fS�7�U���S���� ����DISC                             1LLJRESET        QCPUB           AICS                            MGR     AICS    �fS5�����5�����5����5�������
d  5����AICS            ��E                                                                                                                                   ������������������������STORE/RESTORE-HP/3000.MPEXL  1*� �������B5152AA  C602403/16/010000�������������������������