Kbase 18922: How to Suppress Field Name Column Headings in Results
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/15/1999 |
|
SUMMARY:
By default, Results places field name column headings on the final report. In cases such as reports going to a file for load into a third party program, users may wish to suppress this heading information.
SOLUTION:
1) Begin a Results session and connect to the sports sample database.
2) Add the customer table along with the cust-num, name and address
fields
3) Run the report and notice the field name column headings that are
generated by Results.
4) Back to design view, choose the Query menu option, then Generate.
This will generate Progress 4gl code for the report.
5) Give the file a name and open it up in the procedure editor.
6) Locate in the code where it has COLUMN-LABEL "field name" and
replace both COLUMN-LABEL and its value with the NO-LABEL option.
7) Run this .p again and notice that the column headings do not
appear in the output.
8) Once the report is changed outside of Results, it cannot be run
or opened again from Results. It must be run as a separate .p
file from this point on.