Use a form report to reuse submitted approval data in forms and dashboards. For example, a purchase request report can provide a lookup for a follow-up form, a table of approved requests, and a count by purchase category.
Use a form report for lookups
In a data list, choose a Lookup field. In an approval form, use Lookup or Lookup List. Select the application and form report as the source. For a purchase request lookup, choose a display field readers can recognize and verify that it resolves a known request.
Display report records on a page or form
Choose a presentation control such as Data Table, Gallery, News, or Gantt where available. Select the application and report as its data source, then set display fields and filters. For example, in a data table, show the request title and purchase category and filter to approved requests. Check which records appear using the intended reader’s access.
Measure report records
Choose an analytics control such as Summary, Pie Chart, Column Chart, or Pivot Table. In the example, a column chart uses PR Report. Set Purchase Category as the X-axis category, Asset Category as the subcategory, and Form ID → Count as the Y-axis value.
Compare one group’s total with the matching rows in the report. A report with one row per sublist item can have several rows for the same request. To count requests, use a source with one row per request or use a distinct count where the selected control supports it. Understanding Form Report

