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
Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-9
Setting Up Your Session Environment
For an overview of how to set margins, see Setting Margins on page 4-1.
Figure 2-7. Relation of Window to Output Line
1000
SET LAYOUT
WINDOW
FIRST_NAME;
4
(FIRST_NAME column moves to left edge of window.)
100JERRY
FIRST_NAME LAST_NAME JOBCODE
HOWARD
SET LAYOUT
WINDOW EMPNUM;
3
EMPNUM FIRST_NAME LAST_NAME
JOBCODE
1000
23 ROGER HOWARD
(EMPNUM column moves to left edge of window.)
SET LAYOUT
WINDOW TAB 15
2
MANAGER
LOCATION
DEPTNAME EMPNUM
FINANCE 23
CHICAGO
23
JERRY
FIRST_NAME
(15th position of output line moves to left edge of window.)
MANAGER LOCATIONDEPTNAMEDEPTNUM EMPNUM
FINANCE
23
CHICAGO
23
Default left edge of
window is TAB 1
1
(Screen Position 64)
(Left margin of 5 print positions is part of output line.)
(First position of output line is at left edge of window.)
VST0207.vsd