Support : DialogLink : Online Help : REPORT : Defaults and Restrictions for Reports

REPORT (continued)

Defaults and Restrictions for Reports

Defaults and restrictions apply to reports in these areas:

Line Width
Page Length
Order of Output
Order of Columns of Data
Number of Records

Line Width

The maximum line width for a standard report is 132 characters (240 characters for post-processing formats). The list of available REPORT data fields on each database Bluesheet indicates the width of each field, which includes the two blank spaces automatically inserted between each field column in the table. Therefore, the number of fields (or columns) in a report is restricted to what can fit within a 132-character width.

The default line width in a report is 75 characters per line. If the report you request exceeds the current line width, you will receive the message:

>>>REPORT specified is too wide.
>>>Please reenter command.

Use the SET H command to increase the line width to an appropriate size for both the report and your printer, up to a maximum of 132 characters (e.g., SET H 132). If your display screen is narrower than the report width you set, long lines will probably wrap on the screen, but if your printer can accommodate that line width, the lines will be printed correctly.

Page Length

The page length (length of columns) is set at 20 lines per page. Column headers are repeated at the beginning of each page. To change page length, use the SET V command. For example, SET V 16 sets the page length to 16 lines. To remove all paging and receive a report with no repeated column headers, enter SET V 0 (zero).

Order of Output

The records in a set are displayed in a report in reverse order of their Dialog accession numbers. You can use the SORT command to rearrange the records in a set, and then use the sorted set in the REPORT command.

Order of Columns of Data

Columns of data display from left to right in the order in which the data fields were entered in the REPORT command. A heading above each column identifies the data displayed.

Number of Records

Up to 5,000 records can be included in a standard report.

(Tips for Using REPORT) 

top