SQL/MX Report Writer Guide

Contents

HP NonStop SQL/MX Report Writer Guide—527194-002

Tables

Figure 3-5. Expressions in the Select List 3-23

Figure 3-6. Expressions in the Detail Line 3-24

Figure 3-7. An Invoice 3-28

Figure 3-8. A Report With a Subquery 3-32

Figure 4-1. Default Margin Settings in a Displayed Report 4-3

Figure 4-2. Default Margin Settings in a Printer Report 4-4

Figure 4-3. Pagination Features 4-8

Figure 4-4. Result of Using the NEED Clause 4-9

Figure 4-5. Tabbing to a Display or Print Position 4-12

Figure 4-6. Break Groups 4-16

Figure 4-7. Report and Page Titles 4-21

Figure 4-8. A Page Title With a Row Value 4-22

Figure 4-9. Break Titles 4-24

Figure 4-10. Location of Report and Page Footings 4-25

Figure 4-11. A Page Footing 4-26

Figure 4-12. Break Footings 4-27

Figure 4-13. Numbering Lines 4-29

Figure 4-14. Numbering Break Group Lines 4-30

Figure 4-15. Monetary Total and Subtotals 4-36

Figure 4-16. Sample Decoration 4-37

Figure 4-17. A Report With Totals 4-50

Figure 4-18. Formatted Total Values 4-51

Figure 4-19. A Report With Subtotals 4-53

Figure 4-20. A Report With Subtotals (Page 2 of 2) 4-54

Figure 4-21. Customer Orders Summary 4-56

Figure 4-22. Subtotals on Conditional Values 4-58

Tables

Table 1-1. Report Formatting Commands 1-14

Table 1-2. Report Formatting Command Clauses 1-15

Table 1-3. Style Options 1-15

Table 1-4. Layout Options 1-16

Table 1-5. Report Functions 1-17

Table 1-6. MXCI Commands 1-17

Table 3-1. Search Condition Predicates 3-8

Table 3-2. Comparison and LIKE Predicates 3-13

Table 4-1. Default Display Formats 4-31

Table 4-2. Format Characters in AS DATE and AS TIME Clauses 4-44

Table 4-3. DATEFORMAT Display Formats 4-44