Kbase P79435: How to include ask-at-runtime values in the header of Results report.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/05/2004 |
|
Status: Unverified
GOAL:
How to include ask-at-runtime values in the header of Results report.
FIX:
Although it is not possible include the 'ask-at-runtime' values in the header of Results report directly in RESULTS. It is possible to achieve this by generating the 4GL .p procedure from RESULTS and then modifying FORM HEADER statement of the generated .p file implement this extended feature.
Following is a step by step procedure to demonstrate how to include date 'ask-at-runtime' values in the header of a Results report using this method:
1. Start RESULTS and connect to the sports2000 demo database.
2. Select Query -> Report -> Order ->OK
3. Select the CustNum, OrderNum and OrderDate fields ->OK
4. Select Options -> Headers and Footers and type ?From: To: ? ->OK
5. Select Query ->Generate and type ?fromto.p? the file name ->Save
6. Start the Progress Procedure Editor & connect to the sports2000 database.
7. Open the file ?fromto.p? generated in step 5 above,.
8. Change the statement:
FORM HEADER
"From: To:" + "" FORMAT "x(28)" SKIP(1)
WITH FRAME qbf-header PAGE-TOP COLUMN 1 WIDTH 48 NO-ATTR-SPACE
NO-VALIDATE NO-LABELS NO-BOX USE-TEXT STREAM-IO.
VIEW FRAME qbf-header.
To:
FORM HEADER
"From: " + STRING(qbf-beg-1) + " To: " + STRING(qbf-beg-2) FORMAT "x(40)" SKIP(1) WITH FRAME qbf-header PAGE-TOP COLUMN 1 WIDTH 48 NO-ATTR-SPACE
NO-VALIDATE NO-LABELS NO-BOX USE-TEXT STREAM-IO.
VIEW FRAME qbf-header.
9. Save and Run the program ?fromto.p? from the Procedure Editor.
10. Adjust the header information and formatting to taste.