Page History
This chapter contains reference information for keywords, format modifiers and file creation using the Run_Report command.
Property | Description |
---|---|
Run_Report subroutine | Runs Report Builder reports. |
AVERAGE | The AVERAGE Run_Report keyword is used to generate the average of a numeric column and display it at the end of the report. |
BREAK-ON | Break-On causes Run_Report to put a physical break in the report as the value of a column changes. |
By and By-DSND | Sorts data within a Run_Report report. |
COLFONT | Use Colfont to set the font for a specific column in a report |
COLHDRFONT | Use COLHDRFONT to set the font for the entire header row. |
COLHEAD | Use COLHEAD to create an alternate column heading for a column. |
COLSHADE | This Run_Report keyword is used to set the percentage of shading on a column within the report. |
COLSIZE | Used to determine the width of a column within a Run_Report statement. |
COL-HDR-SUPP | COL-HDR-SUPP suppresses the column headings (column titles) that are automatically printed at the top of each page for each column being displayed. |
DBL-SPC | The modifier DBL-SPC causes a blank line to be printed between each row on the report. |
DET-SUPP | Used with Total and Average, DET-SUPP causes a value to be printed at the bottom of the report, and a subtotal or average to be printed at each control break. |
FONT | Use Font to set the default font for the body of the report. |
Footing | The Footing keyword will cause Run_Report to produce a running page footing (text at the bottom of each page). The footing can contain text, page numbers, dates, and other information. |
FTRFONT | Use FTRFONT to set the font for the report footer. |
Grand-Total | Grand-Total changes the text that accompanies the final total generated by the Total keyword within a Run_Report statement.. |
GRID | GRID will print gridlines between the columns and rows. |
Heading | The Heading keyword will cause the Run_Report command to produce a running page heading. The heading can contain text, page numbers, dates, and other information. |
HDRFONT | Use Hdrfont to set the font for the report heading. |
ID-SUPP | Run_Report will always print the key column in the leftmost column of the report. ID-SUPP causes this column not to be printed. |
JustLen | Use the keyword JustLen to override the justification or display length of a column as stored in the dictionary. You can override the justification or display length separately, or can combine the override specification in one command. |
LANDSCAPE | LANDSCAPE will print the report in landscape mode. |
LEGAL | LEGAL will print the report to legal sized paper dimensions. |
Limit | The Limit keyword restricts the output of data from a multi-valued column to those values that meet specified criteria. |
LPTR | The use of any of these keywords will send the report directly to the default printer. |
(M | Previews the report in a maximized preview window. |
MARGINS | Use MARGINS to specify the margin for pages within a report. |
NUMCOLUMNS | Use NUMCOLUMNS to repeat the selected columns of data within a report. |
OConv | Use the keyword OConv to specify a new or alternate output conversion (output format) for a column. |
(P | The use of any of these keywords will send the report directly to the default printer. |
PAPERSIZE | Use PAPERSIZE to print reports to a specific papersize. |
PORTRAIT | PORTRAIT will print the report in portrait mode. |
PRINTER | The use of any of these keywords will send the report directly to the default printer. |
SCREEN | SCREEN will send the report to the preview window. By default all Run_Report commands use this setting. |
T | The T keyword is used to print the total rows processed at the bottom of the report. |
Total | Total is used to generate the sum of a numeric column and display it at the end of a report generated through Run_Report. |
USING | The Using keyword causes the Run_Report to use a dictionary other than the dictionary of the table being listed or selected. |
Using Format Modifiers in Run_Report Statements | The various format modifier keywords can be inserted anywhere into a Run_Report statement (as long as they are not in the middle of a clause). |
File Creation Using Run_Report | The Run_Report facility allows for the creation of various file types, such as PDF, HTML and RTF. This is accomplished through the use of keywords in the Run_Report statement. |
Search this documentation
Livesearch | ||
---|---|---|
|
Tip | ||
---|---|---|
| ||
This is the home page for your documentation space within Confluence. Documentation spaces are great for keeping technical documentation organised and up to date. |
Panel | ||
---|---|---|
| ||
|
Search this documentation
Livesearch | ||
---|---|---|
|
Popular Topics
Popular Labels | ||||
---|---|---|---|---|
|
Featured Pages
Recently Updated Pages
Recently Updated | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|