Attribute

The attribute that you want to appear on the report. Attributes provide all of the information on the report. For example, if you are creating a report for work orders, work order number, work order type, and scheduled start date are all attributes available from the work order class. You can add attributes from other classes by selecting a join path and then choosing the appropriate attribute. Note that only fields that are saved to the database can be included in reports. Fields that are calculated by APM cannot be included. Each report is limited to one landscape page in width. In order for all of the fields you select to appear when you preview and print the report, you should limit the total number of fields on your report to around 10.

	See Also

Heading

The heading that will appear across the top of the report to describe the information provided by the attribute. APM enters the name of the attribute by default, but you can change the heading if necessary. The width of the column is based on the length of the heading, so you may want to shorten the heading in order to fit more columns across the page. If the heading is shorter than the text in the field, APM will automatically increase the width of the column to display the information properly. Each report is limited to one landscape page in width. In order for all of the fields you select to appear when you preview and print the report, you should limit the total number of fields on your report to around 10.

	See Also

Sequence

The order you want information to appear in your report. APM automatically creates the sequence based on the order in which you select the fields, but you can change the sequence if necessary. Each report is limited to one landscape page in width. In order for all of the fields you select to appear when you preview and print the report, you should limit the total number of visible fields on your report to around 10.

	See Also

Visible

This box shows whether or not the attribute appears in the body of the report. Most fields will be visible. However, you may want some attributes to appear in the report’s header or footer, but not in the body of the report. In this case, clear this option. The field will still appear where you have indicated in the header or footer. Each report is limited to one landscape page in width. In order for all of the fields you select to appear when you preview and print the report, you should limit the total number of visible fields on your report to around 10.

	See Also

Condition

You can select one of these conditions for each attribute on your report. Between: Use this condition to select a range of items to include on the report. Does not contain: If the attribute is a text string, use this condition to filter out strings that contain a specific string. Equal: Use this condition to include only the items that equal the parameter or value you enter. For example, you can select all work orders that have the status “Planned”. Greater Than: Use this condition to include only the items that are greater than the selected parameter or value. Greater Than or Equal: Use this condition to include only the items that are greater than or equal to the selected parameter or value. Less Than: Use this condition to include only the items that are less than the selected parameter or value. Less Than or Equal: Use this condition to include only the items that are less than or equal to the selected parameter or value. Like: If the attribute is a text string, use this condition to include items that contain a specific string. For example, if you enter a string with asterisks such as “*correct*”, you will get values that start or end with “correct”. Not Equal: Use this condition to include only the items that are not equal to the selected parameter or value.

	See Also

Filter values are

You can either enter fixed values for a filter, or enable end users to enter filter values: • Fixed: Enter the value or values that you want to use to filter the items on the report. It is not mandatory to enter data into the filter value fields, but for Fixed values it is highly recommended that you enter appropriate values. If you leave these fields blank, your report may contain no data, or have unexpected results. • Run-time prompt: Select this option to enable end users to choose the filter values on the report’s Print dialog. Run-time prompts allow for very flexible filtering, because end users can determine what information they want to see. When you select this option, you can enter suggested values that can be changed when an end user runs the report.

	See Also

Provide Browse capability

Select this option to allow report users to browse to the value that they want to use to filter the report. For example, to select from a list of asset types.

	See Also

Sorting

Select how the items will be sorted on your report: Ascending: Items with the lowest value or parameter will be listed first, at the top of the report. Descending: Items with the highest value or parameter will be listed first, at the top of the report.

	See Also

Summary

Select what, if any, calculations you want performed on the information in this field: None: Select this option if you do not want any calculations performed on the information in this field. Sum: Select this option to get a total value for all items in this field. Sum only works when the field contains a Number, Date/Time, or Currency. Maximum: Select this option to list the highest value in this field. Maximum only works when the field contains a Number, Date/Time, or Currency. Minimum: Select this option to list the lowest value in this field. Minimum only works when the field contains a Number, Date/Time, or Currency. Average: Select this option to list the average value in this field. The average is calculated by totaling all fields and dividing by the number of items in the list. Average only works when the field contains a Number, Date/Time, or Currency. Count: Select this option to view the number of items in this field. Count works for any field on your report.

	See Also