Customized Report Headings

To create customized report headings:

1. Select Report > User Defined from the menu on the top of the MDS Reports form.

   The MDS Report Headings form is displayed.

2. Click either the On or Off buttons in the Headings field in the MDS Reports Menu to activate or suppress report headings.

   When set to Off, the default report headings are restored.

   

3. Select alternative headings by activating the appropriate checkboxes.

   If headings are changed, then the report must be saved before closing.

4. Select Control > Save as Default Report.

   The saved report is automatically shown in the output report names selection list when the form is dismissed. The modified report is optionally available to other users.

5. Select Control > Reload Default Reports.

Sorting, totalling and sub-totalling

Sorting, totalling, and sub-totalling report options can be:

• Predefined by the administrator

• Overridden by the designer

To configure Sorting, totalling and sub-totalling:

6. Click on the Sorting and Totalling button in the MDS Reports Menu form.

   The MDS Sorting and Totalling form is displayed.

   

   Settings for each column heading in a given report can be defined. If any of the following fields are modified, then the OK button becomes active.

   The options are:

   Sort Precedence:

   Set	Effect
   0	No sorting required.
   1 to n	Sort highest priority to lowest priority.

   Sort Ascending (applicable only when sort priority is active):

   Set	Effect
   Checked	Sort ascending.
   Unchecked	Sort descending.

   Subtotal On Column (applicable only when sort priority is active):

   Set	Effect
   0	No subtotalling.
   1 or n	Provides a subtotal of the referenced column number if any value in that column changes.

   Sort Values:

   Set	Effect
   ON	Values are always output.
   OFF	Values are never output unless a subtotal for this column is output.
   SUB	Values are output if a subtotal for any column is output.
   FIRST	Values are output for the first occurrence of a group of common values in a sorted column.

   Total Column:

   Set	Effect
   Checked	Total for the selected column is output at the bottom of the report.
   Unchecked	Total for that column is not output at the bottom of the report.

7. Click on OK. The form content is checked for validity:

   If no inconsistencies are found, then the criteria of the form are accepted.

   If inconsistencies are found, then a detailed report is generated and a prompt to correct the errors is issued.