|
Edit Report Fields |
  
|
|
Edit Report Fields |
|
This screen provides the mechanism to select and assign individual fields available from a form template to display, sort, group or search within a report. Only fields that are stored in the database can be selected for reporting. Thus HTML and some Label field elements do not appear in the list of reportable field.
The above image shows an overall navigation for a sample Edit Report Fields screen.
Functionalities available within the screen include
• Assign Report Field to a Report
Assign Report Field to a Report
• In the Include column, select the fields required to be available in the Report. These fields will be available in the database view generated
• Modify the Display Name for each of the included fields. Note there is a size limit of 30 characters for the Display Name property. Currently only alpha-numeric and spaces are supported in the Display Name property. By default the Display name is extracted from the ReportFieldName if provided, otherwise the field Name property is used
• Provide a positive numeric value for the Display Order column. If a field is not to be displayed provide 0 as the value.
• Provide the Order By property for the selected field. If not provided the default order is used. There there two possible order value, Ascending and Descending
• Provide the Order By Index property. If 0 is provided it is not used. The Order By Index is used to indicate which ordering of fields to be ordered by
• If required select an item from the Calculate column to have the data participate in statistical analysis. Only fields that are marked with Numeric or Decimal data type can have additional Calculate functions other than Count
• Select Is Searchable if the field can be used as search criteria when querying for report data
• The Type column indicates the type of field element of the selected property.
• Click on Update to apply changes to the database
TIP:
When report fields are created or reassigned, both the stored procedure and database views are re-created. Thus if these have manually been amended to accommodate advanced reporting on form data, they will need to be modified again.