Skip to main content

Utilizing form reports as a data source: A comprehensive guide

Connect a form report to lookup, display, or analytics controls, then check which records appear and how they are counted.

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.

Column Chart settings with PR Report selected as the data source. The chart groups by Purchase Category and Asset Category and counts Form ID.

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

Did this answer your question?