When you produce a report or when you create a query or dialog, you can specify its format. The report produced by your query can present the data arranged in columns (columnar format) or with a separate row on every page (list format).
With the ONLINE EXECUTION panel you can change the default format specified in the query or dialog and select the alternative. When the query specifies PRINT, the data appears in columns. When the query specifies DISPLAY, the data appears in list format. Batch execution does not allow you to change the format specified in the query.
Note: Queries containing DISPLAY statements must be executed in batch if a system printer is chosen.
The following pages show examples of columnar and list formats in reports.
Example - Sample Columnar Report
SLMN-ID NAME YTD-SALES ------- ------------------------------ ------------- 00760 HARTFORD IRON WORKS INC 7,600.00 23160 UNIVERSAL AIRWORKS 231,600.00 00795 NATIONAL HARRIS CORPORATION 7,950.00 34222 CANNON TOOLS CO 3,322,123.00 23615 M.A.C. SAVINGS 236,150.00 11400 MALIRY ENTERTAINMENT INDUSTRY 114,000.00 25155 CHESTERSON-KIDD INC 251,550.00 00655 WEST LIFE INSURANCE 6,550.00 09755 NETTLETON AIRCRAFT 97,550.00 10595 JOHNSON MULTIFOODS 105,950.00 10420 MARK & MARK INTERNATIONAL, INC 104,200.00 05730 BELL-BAKER POWER & SERVICE 57,300.00
Selecting the column option during online execution or using the PRINT statement in your query or dialog creation produces a report with data arranged in columns. Each column has a heading defined in the query or uses the default CA Datacom Datadictionary alternate heading that identifies the field containing the data. In the above sample columnar report, the headings are SLMN-ID, NAME and YTD-SALES.
When a report extends beyond 80 columns, the WRAP and NOWRAP commands control the output display and the User Profile Print Options control the hardcopy report width. See Using Administrative Functions to change the PRINT USING WINDOWS option of your User Profile.
Example - Sample Report in List Format
=> ------------------------------------------------------------------------DQED0 DATAQUERY: ROW DISPLAY ROW 00001 PAGE 00001 ----------------------------------------------------------------------------- SLMN-ID 00760 NAME HARTFORD IRON WORKS INC YTD-SALES 0007600.00
If you choose the list option during online execution or query or dialog creation, CA Dataquery places only one row of information on each page (or panel). The report lists the headings for the columns on the left, as in the sample list report above. The data is listed at the right in the report.
|
Copyright © 2014 CA.
All rights reserved.
|
|