Using the Report Format - Edit screen, you can also:
Using hexadecimal notation
When you see the sign (@) in a column value, means that invalid data has been retrieved from the database. To see the actual value of the bad data, you can display the column in hexadecimal form. Once you have done this, report the value of the column to your support staff.
To display a column in hexadecimal form, type any character under Hex next to that column:
Normal Display Hexadecimal Form JOE@ X'D1D6C5AC'
To change the column from hexadecimal format back to normal display, type a space under hex next to that column.
Editing with code tables
Code tables are tables of values that have been defined in the data dictionary. CA OLQ uses these tables to translate internal codes from the database into a more meaningful external expression of the data.
Here's how the Credit Rating code table looks in the dictionary:
Encoded Value Decoded Value
01 Credit O.K.
02 Rejected
03 Review
etc. etc.
What to do
If your report contains a column of encoded values, you can tell CA OLQ to edit that column with a code table. Type the name of the appropriate code table under Code Table next to that column. You may also need to type a version number for that code table in the Ver entry. If you are unsure of the code table name (or version number) ask your support staff or database administrator (DBA).
Built-in code tables for columns
Some columns have code tables built into them. CA OLQ indicates these columns by displaying the following under Code Table:
**DICT**
If you want to use a different code table, you can type the name of the other code table over **DICT**.
If you don't want to use any code table, type spaces over **DICT**.
Removing columns from your report
To remove a column from your report, type a space or the letter d (for delete) in front of that column. For example, to remove the PHONE and BONUS columns from your report, specify:
X NAME X ID d PHONE X SALARY d BONUS
Bringing a column back
To redisplay a column that you have removed, type any character (other than the letter d) in front of that column.
Note: You cannot redisplay computed columns. Once you have removed them from the report, they cannot be restored.
Fixing columns in place
You can also use the display sequence field to fix one or more columns in position on the Display Report screen. A fixed column always remains on the screen when you scroll right or left.
For example, you can fix the display of EMP-ID so that it always displays at the left margin of your report, no matter how many times you page right or left.
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 104009 DISPLAY RIGHT to see more report columns 125000 Press the ENTER key to go to the next page of the report. DEPARTMENT/EMPLOYEE/EMPOSITION REPORT mm/dd/yy EMP-ID-0415 EMP-FIRST-NAME-0415 NAME EMP-CITY-0415 SS-NUMBER-0415 0030 HENRIETTA HENDON WELLESLEY 011334444 0471 IAN VALIODIS SOMERVILLE 022887770 0471 THEMIS PAPAZEUS NORTHBORO 022887770 0001 JUAN GARCIA BOSTON 013445656 0001 JOHN RUPEE METHUEN 013445656 0472 ROBBY WILDER SOUTHBORO 038779010 0069 JUNE BLOOMER LEXINGTON 039557818 0100 EDWARD HUTTON MELROSE 011223333 0011 RUPERT JENSON MELROSE 022347891 0067 MARIANNE KIMBALL LITTLETON 022778878 0106 DORIS KING MELROSE 067845516 0101 BRIAN NICEMAN MELROSE 033456110 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
The EMP-ID column always appears at the left margin of the report.
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 125000 Press the ENTER key to go to the next page of the report. DEPARTMENT/EMPLOYEE/EMPOSITION REPORT mm/dd/yy EMP-ID-0415 START-YEAR-0415 SALARY-GRADE-0420 SALARY BONUS-PERCENT-0420 0030 73 93 $240,000.00 .010 0471 78 82 $100,000.00 .010 0471 78 72 $90,000.00 .010 0001 75 81 $80,000.00 .010 0001 75 72 $76,000.00 .010 0472 79 81 $90,000.00 .010 0069 80 13 $15,000.00 .004 0100 77 62 $44,000.00 .007 0011 80 72 $82,000.00 .010 0067 78 62 $45,000.00 .007 0106 80 12 $14,500.00 .004 0101 80 12 $14,000.00 .004 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
On your report, fixed columns always appear first (before the regular numbered columns). If you have more than one fixed column, you can switch their positions by typing F1, F2, and so on.
|
Copyright © 2013 CA.
All rights reserved.
|
|