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
Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-6
Report Layout and Style
These are the components of the default report:
•
Detail lines
°
Each detail line contains all elements of the select list in the order you specify
them in the SELECT command. (In Figure 1-2, the select list is the columns
shown on the same line as SELECT.)
°
Values are displayed in the default display formats. The report writer
determines the default display format by the data type defined for a column in
the table definition.
°
The width of a report column is equal to the heading or item width, depending
on which is wider. The report columns are separated by two spaces. Numeric
items are right justified and character items are left justified.
°
Lines are single spaced. If the print line does not fit within the left and right
margins, the line is folded. The place at which the line is broken depends on
the setting of the LOGICAL _FOLDING option.
°
If the print line does not fit on one line because it exceeds the width of the
output device, it is either wrapped to the next line or truncated, depending on
the setting of the WRAP option.
•
Headings
°
Each element that is a table or view column has a column heading consisting
of the heading or column name as defined in the catalog. An element that is an
expression or numeric parameter has the default heading (EXPR). The
headings are underlined and separated from the detail lines by a blank line.
The layout and style options affect the default report. For example, by default the left
margin is 0; the output line begins at the left edge of your screen or printed page. The
right margin is set to the width of the output device. The page length is the current
setting of the PAGE_LENGTH layout option.
By default, the top and bottom margins of a report are each one blank line.
For more information on summaries of the layout and style option, which include the
default setting of each option, see Report Writer Components on page 1-10. For
detailed information about the layout and style options, see the SQL/MP Reference
Manual.
Customized Report
By entering report formatting commands, you can define these additional report
elements:
•
Page title: A page title appears at the top of each page.
•
Report title: The main title of the report appears at the top of the first page (below
the page title, if there is one).