DQHF0
=> --------------------------------------------------------------------------DQHF0 DATAQUERY: REPORT DEFINITION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- ENTER UP TO TWO LINES FOR A REPORT TITLE: => => SELECT THE DESIRED REPORT FORMAT: X COLUMNAR FORMAT: ONE ROW PER LINE. _ LIST FORMAT: ONE ROW PER PAGE. ENTER THE NUMBER OF ROWS TO BE PROCESSED FOR THE REPORT: => ALL ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Purpose
The REPORT DEFINITION panel is not required and you can bypass it. However, if you want to assign a title to your report, display your data one row per page rather than in columnar format, or select fewer than all rows for the report, you will want to make some entries on this panel.
Concepts
These are the major concepts related to this panel:
Title
CA Dataquery allows you to create a two-line title for any report. Each line can be up to 55 characters. All characters are allowed, except for reserved words, listed in the CA Dataquery Reference Guide. When your CA Dataquery system was installed, a title was specified which will appear above the title you define on this panel.
Be sure to see Restrictions on Names for important restrictions on names.
Columnar Format
Data on the report appears in columns, with each line representing one row of the found set.
Name City State Zip
----------- ----------- ------- ------
Allen Dallas TX 75042
Wilson Austin TX 79034
. . . .
. . . .
List Format
Data on the report appears on pages, with one page per found set row, and with one line for each column name printed.
Name Allen
City Dallas
State TX
Zip 75042
Number of Rows
If your query will search a large table and you are only querying the table to see what kind of data is in it, you might only want to see a few of the rows. This causes your query to execute faster and allows you to preview the results before searching the entire database.
Panel Operation
On this panel, you use the Tab key to move the cursor from one field to another, type entries, and press <PF4> CONTINUE to display the next panel. You can accept the defaults and leave off a title by pressing <PF4> CONTINUE without making an entry.
Completed Example
The following completed panel shows how the REPORT DEFINITION panel looks for the sample report.
=> --------------------------------------------------------------------------DQHF0 DATAQUERY: REPORT DEFINITION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- ENTER UP TO TWO LINES FOR A REPORT TITLE: => FILLED CUSTOMER ORDERS => SELECT THE DESIRED REPORT FORMAT: X COLUMNAR FORMAT: ONE ROW PER LINE. _ LIST FORMAT: ONE ROW PER PAGE. ENTER THE NUMBER OF ROWS TO BE PROCESSED FOR THE REPORT: => ALL ------------------------------------------------------------------------------- <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.
|
Field/Item |
Sample Entry |
Reason |
|---|---|---|
|
Title |
Filled Customer |
Explains report's purpose. |
|
Columnar |
X |
To see all the customer data on the report, to make comparisons. |
|
Number |
All |
To get all the data that meets the search criteria. |
Options
If you want to see each order row on a separate page, select the List format. If you only want to see what kind of data was in the table before creating a complex query, change ALL to a small number, like 25.
To Go to the Next Step
With entries complete on the REPORT DEFINITION panel, you are ready to further define the report. Pressing <PF4> CONTINUE displays the next panel.
|
Copyright © 2014 CA.
All rights reserved.
|
|