=> Press <PF1> for help with defining the report --------------------------------------------------------------------------DQF50 DATAQUERY: REPORT FORMAT - COLUMN FUNCTIONS QUERY NAME: TESTEXEC ------------------------------------------------------------------------------- Specify the order in which the columns are to appear on the report by inserting an order number below. Column functions may be selected by placing any character under the corresponding functions. ------------------------------------------------------------------------------- NUMBER| COLUMN NAME | AVG | MAX | MIN | SUM | CNT | TOT ------------------------------------------------------------------------------- 01 | ID | | | | | | 02 | NAME | | | | | | 03 | DEPT | | | | | | 04 | JOB | | | | | | 05 | YEARS | | | | | | 06 | SALARY | | | | | | 07 | COMM | | | | | | | | | | | | | | | | | | | | | | | | | | | - LAST PAGE ------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> NOT USED <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD
Description
This SQL Mode report formatting panel can be accepted with the defaults CA Dataquery assigns, resulting in report data printed in columns in the same order in which it was selected. However, you may want to change the order in which columns are printed. You may also want to request that mathematical functions be performed on some or all numeric columns. If so, you will select math functions for columns. At the end of the report, or at control breaks that you can specify later, you can obtain the results of the functions and specify a special legend to identify them on the report.
Action
Number the columns in the order wanted in the Order Number column. Enter any character in a column function column you want to perform on a particular column. Press ENTER or <PF4> CONTINUE to go on to the next Guided Query panel.
Display Fields
Refer to the following for explanations of the display fields intended to contain variable data.
Name assigned the query you are defining.
Names of the columns you selected.
Columns
Refer to the following for a discussion of each column on this panel.
Numbers appearing in this column are assigned automatically by CA Dataquery. Change the numbers as needed by typing over the current number to indicate the order of columns on the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce an average at control break or at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce the maximum amount found at control break or at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce the minimum amount found at control break or at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce a total at control break or at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce a count of the data items in this column at control break or at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce totals at control breaks and at the end of the report, and for which you do not need to assign legends different from those assigned automatically by CA Dataquery.
PF Keys
The following lists the PF keys for this panel, with a brief description of each function.
Displays Help information about the current panel.
Returns to Report Column Definition (DQHG0) panel.
Displays the next Guided Query panel when this one is complete.
Displays a previous panel, if any.
Displays next panel, if any.
|
Copyright © 2014 CA.
All rights reserved.
|
|