Table — This field displays the name of the current table. To change the table, key in
a table name or select a table using the display list box.
Column List — Below the Table field is a field listing the columns in the current
table. You can select columns from this list to be included or excluded from the report template, depending on the Select All Columns/Select No Columns toggle.
Select All Columns/Select No Columns — This toggle lets you exclude or include
selected columns from the report template. Set the toggle to Select All Columns to select columns to be excluded. Set the toggle to Select No Columns to select columns to be included. Columns are ordered across the page in the order you select them.
Operating Sequence
1. Select Load Default from the Report Builder menu bar.
If you have modified the current report template, the Save Report dialog is called, which lets you write the current report template before loading a default report template. See the section Save Report for information on using this dialog.
The Select Table dialog appears.
2. Select or key in the table for which you want to generate a default report template. Select OK.
The specified template appears.
— OR —
RIS Report Writer Commands N - 5
The Select Columns dialog appears.
Set the Select All Columns/Select No Columns toggle and select the columns to be excluded/included. Select OK.
The specified template appears. 3. Process the template as it appears.
— OR —
Use the commands on the menu bar to change the report template.
There are three ways to display columns that do not fit on the default template: a. Delete unwanted fields, which moves fields over from the right margin. See the
section Delete Field.
b. Increase the Columns Per Page of the template. See the section Edit Report Parameters.
c. Use the Place Line and Place Field functions to add lines with additional fields. See the sections Place Line and Place Field.
__________________________________________________________________________________________________________________________________________________
Numeric
The Numeric command lets you place a field that performs a specified calculation for the numeric values in a column. A numeric field can calculate integer or floating point column values.
You can specify update and reset conditions, as well as calculate subtotals. Numeric fields used for subtotals and totals are usually placed on body lines and final lines respectively. Numeric fields are not allowed on All Table lines.
Join columns let you use a single table report to report on more than one table. Any two database tables that have columns with common values can be joined. See the section Join Columns.
RIS Report Writer Commands N - 7
Dialog Options
When you select Numeric, the Numeric Field dialog appears.
The following list describes the options on the menu except for the Print Condition field, which is described in the section Place Field.
Calculation — This checklist lets you select the type of calculation that will be
performed.
— Total —Sums the column’s values.
— Average — Averages the column’s values.
— Minimum — Prints the minimum value for the column. — Maximum — Prints the maximum value for the column. — Percentage — Prints the percentage of the total of the column.
Schema — This field specifies the schema containing the table for which you want to
place a numeric field. You can key in a new schema name or use the list indicator to select a new schema.
Table — This field specifies the table for which you want to place a numeric field. You
can key in a new table name or use the list indicator to select a new table.
Column — This field specifies the column from the current table for which you want to
place a numeric field. You can key in a new column name or use the list indicator to select a new column.
Join Columns — This button lets you review and edit the join column relationship.
The button is inactive until join columns are specified.
If you place a numeric field from a table other than the current table on a single table report, you must specify a join column between the primary (that is, the current) table and the secondary table. See the section Join Columns.
Length — This field specifies the length of the numeric field.
Decimal Places — This field specifies the number of decimal places for floating point
data.
Update Condition — This field lets you specify a condition which must exist for the
field to be incremented. If the Update Condition field is blank, the numeric field is incremented for every row.
Reset Condition — This field lets you specify a condition which must exist for the
field to be reset to zero. If the Reset Condition field is blank, the numeric field is not reset.
Operating Sequence
1. Select Numeric from the Report Builder menu bar. The Numeric Field dialog appears.
2. At the Column field, enter the name of a column from the current table using key-in or the list indicator. Go to Step 5.
— OR —
At the Schema or Table field, enter a new schema or table using key-in or the list indicator.
The Join Columns dialog appears.
3. At the Column field for the primary table, enter the name of the join column using key-in or the list indicator. Repeat for the secondary table.
— Then —
Specify whether the join is an outer join. Select OK to return to the Numeric Field dialog.
RIS Report Writer Commands N - 9
The Join Columns dialog disappears. The Join Columns button on the Numeric
Field dialog is active.
4. At the Column field on the Numeric Field dialog, use key-in or the list indicator to enter the name of the column from the secondary table for which you want to place a field.
5. Set any other parameters as needed. Select OK.
The field is dynamically attached to the cursor. The values in the message area can help you position the field on the dialog. RIS Report Writer uses F-1, F-2, and so on to represent the first, second, and any subsequent fields on a line.
6. Click the middle mouse button to place the field.
The field is inserted before the current field (if any), with one space separating the two fields. Any fields to the right of the new field may shift to the right.
You can realign the fields using the following commands:
Copy Field Delete Field
Undelete Field (Report Builder)
Insert Space (Report Builder) Delete Space
— OR — Select Cancel to end the placement.
Once you establish a join column between two tables, you can place additional numeric fields from the secondary table. The Join Columns dialog does not reappear.
RIS Report Writer Commands P - 1
__________________________________________________________________________________________________________________________________________________
Page
The Page command places a field that prints the report page number. You usually place page fields on a top or bottom line.
Dialog Options
When you select Page, the DBA Page Field dialog appears.
The following list describes the options on the menu except for the Print Condition field, which is described in the section Place Field.
Length — This field lets you specify the length of the page field.
Current page/Total pages — These radio buttons let you specify the page number to
print out in the page field. If you choose Current Page, the current page of your report prints in the page field of each page. If you choose Total Pages, the total number of pages in the report prints in the page field of each page.
Operating Sequence
Place this field using the standard Place Field operating sequence. See the section Place Field for a description of this sequence.
RIS Report Writer Commands P - 3
__________________________________________________________________________________________________________________________________________________