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
iv
Figures (continued)
Figures (continued)
Figure 4-27. Splitting Double-Byte Characters With an Odd-Numbered Display
Descriptor 4-63
Figure 4-28. Splitting Double-Byte Characters With Incorrectly-Sized Display
Descriptors 4-64
Figure 4-29. Splitting Double-Byte Characters With the TAB Clause 4-65
Figure 4-30. Splitting Characters With Different Break and Subtotal Columns 4-66
Figure 4-31. Splitting Characters With Same Break and Subtotal Columns 4-67
Figure 4-32. Using an Even-Numbered Display Descriptor for Subtotal Labels 4-68
Figure 4-33. Using a Correctly-Sized Display Descriptor for Subtotal Column
Lables 4-69
Figure A-1. Enform Report and SQLCI Report A-2
Tables
Table 1-1. Report Formatting Commands 1-12
Table 1-2. Report Formatting Command Clauses 1-12
Table 1-3. Style Options 1-13
Table 1-4. Layout Options 1-14
Table 1-5. Report Functions 1-14
Table 1-6. SQLCI Commands 1-15
Table 3-1. Search Condition Predicates 3-7
Table 3-2. Comparison and LIKE Predicates 3-12
Table 4-1. Default Display Formats 4-28
Table 4-2. Format Characters in AS DATE and AS TIME Clauses 4-41
Table 4-3. DATEFORMAT Display Formats 4-42
Table A-1. Enform Statements A-3
Table A-2.
Enform Clauses A-3
Table A-3.
Enform Option Variables A-5
Table A-4. Enform System Variables A-6
Table A-5. Enform Commands A-6