Task: Copy and change the report SAMPLE4 as follows:
1: Change the transaction modes for reporting.
2: Add a preface.
3: Underline the field headers.
4: Add text explaining the data shown at the control break.
5: Add grand total with explanatory text.

This transaction takes the report SAMPLE4 and uses the Layout Editor to make it more understandable.

Line and field commands in the Layout Editor are shown using the period (.) as escape character. Use the escape character defined at your site. The escape character defined at your site is displayed in the delimiter information section of the Layout Editor.

Transaction Specification

Primary File	SAG-TOURS-E-CRUISE
Display Fields	1: CRUISE-ID 2: START-HARBOR 3: DESTINATION-HARBOR 4: START-DATE
Selection Criteria	CHARTER-YACHT-TYPE = 'ATLANTIC 29'
Control Field	START-DATE
Special Break Conditions	First 'n' characters: 6
System Functions	Count CRUISE-ID Grand Total Count CRUISE-ID

This section covers the following topics:

• Create the Transaction SAMPLE5

---

Create the Transaction SAMPLE5

To Access the Transaction List Screen

• Issue the TRANSACTION command.

  Or:
  Select Transactions from the Main Menu.

  Or:
  If you are within a transaction, issue the EXIT or CANCEL commands until the Transaction List screen appears.

To Copy Transaction SAMPLE4

1. Issue the COPY TRANSACTION SAMPLE4 command.

   The Copy window appears.

2. Enter "SAMPLE5" in the Target Object window.

   The transaction is copied to the name SAMPLE5 and appears in the Transaction List screen.

3. Enter "Layout Editor in the Description field" next to SAMPLE5 (optional).

To Change Transaction Report Level and Destination

1. Enter MO in the command column next to SAMPLE5.

   The Worksheet appears.

2. Issue the MODES command.

   The Transaction Modes Reporting window appears.

3. Enter "D" in the Report Level field.

4. Enter "S" in the Destination field.

5. Press Enter.

   The Transaction Modes Reporting window closes.

To Add Grand Total

1. Enter "SF" in the Function (Func) column next to the field CRUISE-ID.

   The Specify System Functions window appears.

2. Enter any non-blank character in the Cnt column next to Grand Control field.

To Invoke NATURAL REPORT MANAGER

• Issue the LAYOUT command. You can abbreviate this to LAY.

  A default layout is generated from the transaction specification.

  The Layout Overview screen appears:

  15:20 *** NATURAL REPORT MANAGER *** 1998-02-26 Layout LSAMPLE5 - Layout Overview - NRMPAGE +------------------------------------+ I Title I +------------------------------------+ +------------------------------------+ I Header I +------------------------------------+ +------------------------------------+ I List I I I +------------------------------------+ +------------------------------------+ I Group I I I I 1 10 I I I I I +------------------------------------+ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip Tech Canc

  You are now using the product Natural Report Manager.

  The Title element contains the standard title for your site. The List element contains the fields you have selected to be displayed.

To Add Preface

1. Issue the EDIT PREFACE command.

   The Layout Editor appears. The editor area is empty.

2. Type text for a preface in the editor area as shown below:

   Do not type in the first column of the editor area as this is reserved for delimiters.

   17:16 *** NATURAL REPORT MANAGER *** 1998-02-26 Layout LSAMPLE5 - Layout Editor - NRMEDIT More: + > Transaction Fields Delimiter Class Attrib. Color 1 CRUISE-ID N8.0 Blank Text Default 2 CRUISE-TYPE A1 _ Text Intens. 3 CRUISE-STATUS A1 ( Output Default . START *G1 ) Output Intens. 4 START-DATE N8.0 5 START-TIME N6.0 Escape Char. = , Header Char. = & Top ---010---+----+----+---030- ( Preface ) ---050---+----+----+---070--- Typ Pre PREFACE Pre Pre This transaction uses data from the file SAG-TOURS-E-CRUISE. The Pre report shows cruise IDs, start harbor, destination harbor and Pre starting date for cruises which use yachts of type Atlantic 29. Pre The data is sorted according to cruise starting date. Pre At the end of each month, the number of cruises in that month is Pre shown. The total number of cruises is shown at the end of the Pre Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip - + Tech < > Canc

   Each text constant must be preceded by a delimiter of the class TEXT.

   The last word of the preface does not fit into the editor area shown.

3. Issue the ..I line command in the last line of text.

   A line is inserted after the last line of text (you cannot see it).

4. Press PF8 to page forwards.

5. Enter report as the last word of the preface.

6. Press PF7 to page backwards.

   The report requires that the word PREFACE be highlighted.

7. If you have a delimiter for intensified text, type it before the word Preface.

   The delimiter for intensified text in the example is '_'.

To Center the Text

1. Issue the ..C line command in the same line as the word PREFACE.

   The word PREFACE is centered.

2. Issue the ..C* line command in the next line of text.

   The line is centered and all the lines below are moved the same distance to the right but are not centered.

   Because the Scan Right (>) function is available, you can see that the report is wider than the screen.

   Top ---010---+----+----+---030- ( Preface ) ---050---+----+----+---070--- Typ Pre _PREFACE Pre Pre This transaction uses data from the file SAG-TOURS-E-CRUISE. The Pre report shows cruise ID's, start harbor, destination harbor and Pre starting date for cruises which use yachts of type Atlantic 29. Pre The data is sorted according to cruise starting date. Pre At the end of each month, the number of cruises in that month is Pre shown. The total number of cruises is shown at the end of the Pre Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip - + Tech < > Canc

   You now need to enter two lines of blanks at the end of the Preface. Because you are at the end of the editor area, you must first create the lines.

3. Issue the ..R(2) line command at the beginning of the last line of text.

   The last line of text is copied twice.

4. Overtype the two new text lines with blanks.

To Underline Header

1. Issue the EDIT HEADER command.

   The Header element appears in the editor area. The Header element contains the headers currently defined for the output fields.

2. Type plus signs ("+") under the header fields.

To Add Text Explaining the Data at Control Breaks

1. Issue the EDIT GROUP1 command.

   The Group1 element appears in the editor area as follows:

   All ---010---+----+----+---030-- ( Group1 ) ---050---+----+----+---070--- Typ ** Control Break (1) ** G1_ START-DATE : )S00000000 G1_ Cnt )S0000000 G1_ G1_ ___ ___ ___ ___ ___ You are on the first page. Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip - + Tech < > Canc

   The Group1 element contains the information displayed at the (first) control break.

2. Overtype the line which contains the text "** " Control Break (1) **with blanks.

3. Type the .M field command in the field )S00000000 next to the text START-DATE.

4. Position the cursor in the same line in column 050 (under 050 in the scale).

5. Press Enter.

   The field is moved so it starts under the 050 in the scale.

6. Type the .M field command in the field )S00000000 next to the text Cnt.

7. Position the cursor in the same line in column 050 (under 050 in the scale).

8. Press Enter.

   The field is moved so it starts under the 050 in the scale.

9. Type the .D field command in the field START-DATE.

   The field is deleted.

10. Overtype the colon (:) with a blank.

11. Type the text Last Starting Date: next to the first field )S00000000 starting the text at column 019.

12. Type the .D field command in the field Cnt.

    The field is deleted.

13. Type the text Number of Cruises this Month: next to the second field )S00000000 starting the text at column 019.

    The editor area now has the following contents:

    All ---010---+----+----+---030-- ( Group1 ) ---050---+----+----+---070--- Typ G1_ Last starting date: )S00000000 G1_ Number of Cruises this Month: )S0000000 G1 ___ ___ ___ ___ ___ ___ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip - + Tech < > Canc

To Add Text Explaining the Data at the Grand Total

1. Issue the EDIT GROUP10 command.

   The Group10 element appears in the editor area as follows:

   All ---010---+----+----+---030- ( Group10 ) ---050---+----+----+---070--- Typ ** Grand Totals ** G10 Cnt )S0000000 G10 G10 ___ ___ ___ ___ ___ ___ You are on the first page. Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip - + Tech < > Canc

   The Group10 element contains the information displayed at the Grand Total.

2. Issue the ..D line command in the line which contains ** Grand Totals ** .

   The line is deleted.

3. Type the .M field command in the field )S00000000 next to the text Cnt.

4. Position the cursor in the same line at column 050.

5. Press Enter.

   The field is moved.

6. Enter the .D field command in the field Cnt.

   The field is deleted.

7. Enter the text Total Number of Cruises: next to the field )S00000000 starting the text at column 019 (overtype the equals (=) sign).

   All ---010---+----+----+---030- ( Group10 ) ---050---+----+----+---070--- Typ Total Number of Cruises: )S0000000 G10 G10 G10 ___ ___ ___ ___ ___ ___ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip - + Tech < > Canc

To Test the Layout

1. Issue the TEST command.

   The whole layout appears as it would if the transaction were run except for that the output fields and the standard title are filled with dummy data.

   17:44:05 SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 98-02-26 LSAMPLE5 SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 1 SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS PREFACE This transaction uses data from the file SAG-TOURS-E-CRUISE. The report shows cruise ID's, start harbor, destination harbor and starting date for cruises which use yachts of type Atlantic 29. The data is sorted according to cruise starting date. At the end of each month, the number of cruises in that month is shown. The total number of cruises is shown at the end of the report. CRUISE-ID START-HARBOR DESTINATION-HARBOR START-DATE +++++++++ ++++++++++++ ++++++++++++++++++ ++++++++++ 9 AbcDefGhijAbcDefGhij AbcDefGhijAbcDefGhij 9 9 AbcDefGhijAbcDefGhij AbcDefGhijAbcDefGhij 9 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Print Exit Flip Canc

2. Page through the layout to make sure that it is what you want.

To Look at Layout Overview Screen and Worksheet (Optional)

1. Press PF2.

   The Layout Overview screen appears:

   11:35 *** NATURAL REPORT MANAGER *** 1998-03-01 Layout LSAMPLE5 - Layout Overview - NRMPAGE +-----------------------------------------------------------+ I Title I +-----------------------------------------------------------+ +-----------------------+ +--------------------------------+ I Preface I I Header I I I +--------------------------------+ I I +--------------------------------+ I I I List I I I I I I I +--------------------------------+ I I +--------------------------------+ I I I Group I I I I I I I I 1 10 I I I I I I I I I +-----------------------+ +--------------------------------+ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Set Exit Field Edit Flip Tech Canc

   The preface element you have created is now shown.

2. Press PF8.

   The Worksheet appears:

   11:36 ***** Super Natural ***** 1998-03-01 SAMPLE5 - Worksheet - SN3011 Ref DB Field Name Seq S/C Func Def Info Del AA 1K CRUISE-ID ...................... L__ ___ >_ __ __ __ AE 1K 2 START-DATE ..................... L__ C1_ >_ __ __ __ AJ 1K START-HARBOR ................... L__ ___ __ __ __ __ AK 1K DESTINATION-HARBOR ............. L__ ___ __ __ __ __ AP 1 2 CHARTER-YACHT-TYPE ............. ___ ___ __ __ __ __ BI V *TIMX .......................... L__ ___ __ __ __ __ BJ V *DATX .......................... L__ ___ __ __ __ __ BK V *PROGRAM ....................... L__ ___ __ __ __ __ BL V *PAGE-NUMBER ................... L__ ___ __ __ __ __ BM ________________________________ ___ ___ __ __ __ __ BN ________________________________ ___ ___ __ __ __ __ BO ________________________________ ___ ___ __ __ __ __ BP ________________________________ ___ ___ __ __ __ __ BQ ________________________________ ___ ___ __ __ __ __ Layout has been successfully modified Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Next Exit Field Incl Flip - + Sel Run Canc

   There is an "L " in the Sequence (Seq) column next to fields used in layout elements. You cannot use the Sequence (Seq) column for these fields until you have deleted them from the layout element.
   The system variables which are part of the standard title (*TIMX, *DATX, *PROGRAM and *PAGE-NUMBER) appear in the Field Name column and are marked with V in the Database Reference (DB) column.

To Run the Transaction

• Issue the RUN command. In Natural Report Manager, the RUN command is not assigned to PF11.

  The report is generated. Some screens from the report are shown below:

  17:50:22 CHARTER-YACHT-TYPE = 'ATLANTIC 29' 1998-02-26 ISAMPLE5 1 PREFACE This transaction uses data from the file SAG-TOURS-E-CRUISE. The report shows cruise ID's, start harbor, destination harbor and starting date for cruises which use yachts of type Atlantic 29. The data is sorted according to cruise starting date. At the end of each month, the number of cruises in that month is shown. The total number of cruises is shown at the end of the report. Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Print Exit Flip + Canc

  14:28:26 CHARTER-YACHT-TYPE = 'ATLANTIC 29' 1998-03-01 ISAMPLE5 2 CRUISE-ID START-HARBOR DESTINATION-HARBOR START-DATE +++++++++ ++++++++++++ ++++++++++++++++++ ++++++++++ 79 KIEL KIEL 19910330 92 KIEL KIEL 19910330 106 KIEL KIEL 19910330 Last starting date: 19910330 Number of Cruises this Month: 3 80 KIEL KIEL 19910406 107 KIEL KIEL 19910413 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Print Exit Flip + Canc

  17:51:14 CHARTER-YACHT-TYPE = 'ATLANTIC 29' 1998-02-26 ISAMPLE5 9 CRUISE-ID START-HARBOR DESTINATION-HARBOR START-DATE +++++++++ ++++++++++++ ++++++++++++++++++ ++++++++++ Last starting date: 19911026 Number of Cruises this Month: 4 Total Number of Cruises: 41 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Print Exit Flip + Canc