Previous Topic: Step 2 - Display your reportNext Topic: Step 1 - Change your column headers

How to Format Your Report › Changing Column Headers

Changing Column Headers

In this step, you use the Report Format - Header screen to:

To get to the Report Format – Header screen, type header in the command line of any screen.

     CA OLQ Release nn.n                       *** Report Format - Header ***
 ->header                                        Page     1 of     1
134000 Specify column headers and press the ENTER key

 Underline character:                  Disp
                                       Seq              Header
   DEPARTMENT
 X  DEPT-ID-0410                         1 DEPT-ID-0410
   EMPLOYEE
 X  EMP-LAST-NAME-0415                   2 EMP-LAST-NAME-0415
   EMPOSITION
 X  SALARY-AMOUNT-0420                   3 SALARY-AMOUNT-0420









 Compute:

 1=HELP    3=QUIT    4=MESSAGE    5=DISPLAY    6=MENU    10=SORT    11=EDIT

Default column headers

When you build a report, CA OLQ automatically creates column headers for you. These default headers come from the names of the columns in the database or from CA OLQ headers defined in the dictionary.

Changing the defaults

To change the default column headers, type over the text in the Header entry. You can change any or all of the headers in the report. Each header you type can be from 1 to 37 characters long.

Typing multiword headers

You can type headers that contain more than one word. To make a multiword header appear on a single line, type quotes around it. Otherwise, each word of the header appears on a separate line of the report. For example:

Input:

         Last Name                   "Last Name"

Output:

           Last
           Name                       Last Name
    ────────────────────         ────────────────────
    Jones                        Jones
    Smith                        Smith
    Whipple                      Whipple

Session Options That Affect Report Headers:

Session Option

Function

Header

CA OLQ displays column headers on your report

Noheader

CA OLQ displays the report without headers (even if you've created new headers on the Report Format - Header screen)

Olqheader

CA OLQ uses any headers you've typed on the Report Format - Header screen (or that have been created in the data dictionary)

Noolqheader

CA OLQ ignores your headers and uses the column names from the database as the headers on the report

To get to the Session Options screen, type options on the command line and press [Enter].

Underlining column headers

Underlining column headers can make them easier to read. CA OLQ uses the dash (-) character to draw these lines.

To change the underline character, type the character you want to use next to Underline Character. If you don't want underlining on your report, type a space here.