Help

Reports. View all existing reports, save a new report, and save an existing report with a new name.

Help

Data Sources. Select the data sources for your report. You can select more than one data source.

• Table - Lists the available tables and views.
• Join Field – Lists the available fields from your selection above. Your selection here must match your selection in Field.
• Foreign table – Lists the tables and views available to join with your selection in Table.
• Field – Lists the available fields from your selection above. Your selection here must match your selection in Join Field.

Help

Fields. Add and delete fields from your selected data sources. Sort the fields and perform sort and perform functions

• Field: Lists all fields available from the tables and views selected in Data Sources.
• Description: Describes the field. Defaults to field name, but can be edited.
• Sort A: Sort by the selected Field.
• Sort D: Sort by the selected Description.
• VG: Visually groups the fields in your report.
• A: Allows you to add, subtract, multiply, or divide by the selection in the row above. Click the box to.
• Function: Allows you to perform a function on the selected Field.
• Format: Allows you to format the selected Field.

You can add a summary line to all numeric fields using:

• Avg – the average of the fields
• Count – counts how many
• Count Distinct – counts everything only once
• Min value – Minimum value of the total
• Maximum value – Maximum value of the total
• Sum – Adds the total

Field|Value. Shows field and value for every pair.

Help

Filters. Filter available fields.

• Filter Field: - Lists the available fields.
• Operator: – Lists the operations available for the above field.
• Value(s): - Allows you to input conditions for the operation.
• Blank: - Check the box to return results with the value or a blank (null).
• Param: – Check the box to allow users to modify the parameter from the report viewer.