SQL/MP Report Writer Guide
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 Introduction to the NonStop SQL/MP Report Writer
- 2 Using SQLCI and the Report Writer
- 3 Selecting Data for a Report
- 4 Customizing a Report
- Defining the Layout
- Specifying the Items in a Detail Line
- Naming Select List and Detail Line Items
- Organizing Rows Into Break Groups
- Labeling Information
- Formatting Data Values
- Formatting Dates and Times
- Using TACL to Pass Parameters
- Conditional Printing of Items or Line Entries
- Redefining Special Characters
- Calculating Totals
- Calculating Subtotals
- Printing Double-Byte Characters
- A Comparison of the Report Writer and the Enform Language
- Index
Contents
HP NonStop SQL/MP Report Writer Guide—527213-001
iii
Figures (continued)
Figures (continued)
Figure 2-11. Example of Using the Report Writer to Produce Text From Data 2-22
Figure 2-12. Example of Using the Report Writer to Produce Text From Data 2-23
Figure 2-13. Example of Using the Report Writer to Produce Text From Data 2-24
Figure 3-1. Plan for Report Content 3-3
Figure 3-2. Sample Rows from Joined Tables 3-4
Figure 3-3. Example of Rows Sorted by One Column 3-14
Figure 3-4. Example of Rows Sorted by Two Columns 3-15
Figure 3-5. Expressions in the Select List 3-22
Figure 3-6. Expressions in the Detail Line 3-23
Figure 3-7. Example of an Invoice 3-28
Figure 3-8. Example of Report With a Subquery 3-32
Figure 4-1. Default Margin Settings - Displayed Report 4-2
Figure 4-2. Default Margin Settings - Printer Report 4-3
Figure 4-3. Example of Pagination Features 4-6
Figure 4-4. Result of Using the NEED Clause 4-8
Figure 4-5. Tabbing to a Display or Print Position 4-11
Figure 4-6. Example of Break Groups 4-15
Figure 4-7. Example of Report and Page Titles 4-19
Figure 4-8. Example of a Page Title With a Row Value 4-20
Figure 4-9. Example of Break Titles 4-22
Figure 4-10. Location of Report and Page Footings 4-23
Figure 4-11. Example of a Page Footing 4-24
Figure 4-12. Example of Break Footings 4-25
Figure 4-13. Example of Numbering Lines 4-27
Figure 4-14. Example of Numbering Break Group Lines 4-27
Figure 4-15. Example of Monetary Total and Subtotals 4-33
Figure 4-16. Example of a Decoration 4-34
Figure 4-17. Example of TACL Macro for Passing Parameter 4-44
Figure 4-18. Example of a Report With Totals 4-50
Figure 4-19. Example of Formatted Total Values 4-51
Figure 4-20. Example of Report With Subtotals (Page 1 of 2) 4-53
Figure 4-21. Example of Report With Subtotals (Page 2 of 2) 4-54
Figure 4-22. Customer Orders Summary 4-56
Figure 4-23. Example of Subtotals on Conditional Values 4-58
Figure 4-24. Splitting Double-Byte Characters With Text Wrapping 4-60
Figure 4-25. Using the SPACE Clause to Adjust Display Columns 4-61
Figure 4-26. Using the TAB Clause to Adjust Display Columns 4-62