Skip to main content

Understanding Form Report

Turn approval form submissions into a searchable report. Choose variables and sublist fields, then verify views and access permissions.

What a form report shows

Use a form report to review information from approval form submissions. For example, create a Purchase Requisitions report so reviewers can find requests by status or requester.

A form report presents submitted records from a selected approval form. A request-level report shows one row per included request and can display the variables you choose, such as the requester, status, and total amount.

Choose the source records and fields

From + Add Component, choose Form report. In the wizard, select the source approval form and name the report. Set any record filters, then select the variables to include and review their field names and data types before publishing. Create form reports

Show approval form sublist items

To show details such as quantities and unit prices, choose a sublist in Sub list fields and add the child fields you need. A request with three items in the selected sublist produces three rows. Use a separate form report for each additional sublist you need to review.

The Form report wizard showing Sub list fields with Name, Style, Quantity, and Unit Price selected.

Set up data views

Create views for different tasks, such as All requests, Approved requests, and My purchase requests. Set the filters and access for each view. Test with a request that should appear and one that should be filtered out. In a sublist report, also compare the row count against the items on the source request.


Check report permissions

Choose whether the report inherits application permissions or has its own access settings. Check the options for opening request details and exporting records. Use a reader account to verify which views, rows, details, and export actions are available.

Did this answer your question?