Using GUIDE in DQL Mode › Creating a Sample › Step 13: Assign a Legend to the Average Ship Price

Step 13: Assign a Legend to the Average Ship Price

DQHO0

 =>

 --------------------------------------------------------------------------DQHO0
 DATAQUERY:  COLUMN FUNCTION LEGENDS                QUERY NAME: USER-SAMPLE
 -------------------------------------------------------------------------------
 Enter a legend to be displayed with the result of the indicated function
 during control break processing.
 Defaults are provided and can be modified.
 -------------------------------------------------------------------------------
 FNC | TABLE NAME/COLUMN NAME           | LEGEND
 -------------------------------------------------------------------------------
     |TEMPORARY RESULT                  |
 AVG | SHIP-PRICE                       | AVERAGE   SHIP-PRICE
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Purpose

The optional COLUMN FUNCTION LEGENDS panel allows you to assign a legend to the printed results of each column function you selected. This legend appears next to the results and describes the value of the function that appears on the report.

Panel Operation

On this panel, the Tab key moves the cursor from one Legend field to another. You can type over the default, if you like, and press <PF4> CONTINUE to display the next panel.

Completed Example

The following completed COLUMN FUNCTION LEGENDS panel gets the results of averaging the item price.

 =>

 --------------------------------------------------------------------------DQHO0
 DATAQUERY:  COLUMN FUNCTION LEGENDS                QUERY NAME: USER-SAMPLE
 -------------------------------------------------------------------------------
 Enter a legend to be displayed with the result of the indicated function
 during control break processing.
 Defaults are provided and can be modified.
 -------------------------------------------------------------------------------
 FNC | TABLE NAME/COLUMN NAME           | LEGEND
 -------------------------------------------------------------------------------
     |TEMPORARY RESULT                  |
 AVG | SHIP-PRICE                       | AVERAGE SHIPPING PRICE
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

This chart explains each entry/selection.

Options

You could use a special symbol designated by your site to print the current value of the control break column as part of the legend. To find out which character acts as your heading substitution character, look at the System Profile topic after displaying Topic Help with the HELP command. For instance, if the symbol were &&, you might write Customer && Average Price: as the legend.

To Go to the Next Step

The calculation that will print the average of the item prices has a legend. Since the default format is acceptable, this example skips the next panel, FUNCTION RESULT PRINT FORMAT.

The following chart describes the panel to be skipped and the reason for skipping it. For detailed information about the panels, please see the CA Dataquery Reference Guide.