Database Statistics [RPSTAT] (R1-NA)

Article • 6/8/2026 • 2 min read

Use the Database Statistics report parameter interface to generate information of the tables that hold information for your company. It may be necessary to review or monitor this on an arranged basis.

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria. For more information on Advanced Filters, click here.

To generate Database Statistics Report

  1. Click the Utilities tab.

  2. From the Utility Reports group, click the Utility Reports > Database Statistics .
    Or
    Press Alt+R, type RPSTAT, and click OK.

  3. From the Selection box, select All Files to view all the files information.

  4. In the Sort Order field, select how to sort the report.

    The Sort On field is populated based on the order selected in the Sort Order field.

  5. In the Layout area, select the layout in which you want to view the report.

    The Layout field is populated based on the type of report selected in the Selection field.

  6. Select the Summary check box to obtain a high level data report.

  7. In the Sort Range area, you can sort the information from the available sort range.

    TheSort On field is populated based on the type of report selected in the Selection field.

    The available sort ranges are:

    • Single : Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

      • Type the item reference in the From field.

      • Click the lookup reference and select the sort item from the Lookup for From. Highlight the required sort item and click Select.

    • Range : Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

      • Type the first and last values of the range in the From and To fields.

      • Click the lookup reference (if available) and select the sort item from the Lookup. Highlight the required sort item and click Select.

    • All : Select this to include all available items.

  8. Click Display on the Active Form ribbon to generate the report.

    For more information about theActive Form ribbon options, see Active Form ribbon.

​