Setting Limits on the Number of Display Items

The Max Items to Display options enable you to designate the maximum number of items returned when users run specific queries and the maximum number of items that display per page for report and search results. If the maximum setting is exceeded, a warning message displays to users. Keep in mind that displaying a large number of items can affect the system's performance.

To set maximum numbers of items on lists:

  1. From the Options menu, select Settings or click the Settings icon on the toolbar.
  2. Select the Display tab.
  3. In the Listing Report Items setting, select the maximum number of items that are returned in lists of items. For example, when users run Listing reports, the number specified here is the maximum number of items that will be returned. This setting controls search results, mass update lists, Relational Field Value Lookup searches. The default setting is 1,000 items.
  4. In the Scheduled Report Items (Excel) and Scheduled Report Items (PDF) settings, select the maximum number of items that are included in scheduled reports that are e-mailed to users based on the format they select for the following types of reports:
    • Listing
    • Reports with join conditions
    • Change History
    • Deleted Items
    • State Change
    • Version Control Access
    • Multi-Table
    The default setting is 1,000 items for Excel and 200 for PDF. PDF reports are limited to 500 items.
  5. In the Detail Report Items setting, select the maximum number of items that are returned when users run Details reports or selects the Details view on a list of items. The number specified must be smaller than that set for the Listing Report Items setting. The default setting is 200 items.
  6. In the Items Per Page setting, select the maximum number of items users can display per page. This setting overrides the Items Per Page user preference. For example, if the Items Per Page setting on the Settings – Display tab is set at 50, the Items Per Page user preference cannot be set to more than 50. Users can, however, display all items returned in a report by clicking the All link at the bottom of the Item List pane.
  7. In the Searchable Field Values setting, select the number of items to display when users perform a search using the Value Find capability. The default setting is 250 items.
  8. Click OK.