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. |
