All topics
English

Build and use reports · 3 min read

Build a policy table with columns and filters

Create work lists for pending documents, renewals and portfolio checks.

In this guide
  1. Choose table columns
  2. Filter pending documents
  3. Combine dates and conditions deliberately
  4. Sort, paginate and open records
  5. Separate temporary filters from saved settings
  6. Keep learning

For: CRMDAY One users with the Insurance profile.

Choose table columns

  1. Create a Policies report and select Table.
  2. Click Add or remove columns; search and select fields.
  3. For pending documents, choose Policy number, Contact, Status, Carrier and Pending DMI. Add dates or Owner if useful.
  4. Finish selection, then use arrows to reorder columns or remove unwanted ones.

Select up to 30 columns, subject to field access. In Summary and Matrix, Record columns controls the drill-down detail.

Column catalog with record and related-contact fields.
Column catalog with record and related-contact fields. Open the image to enlarge it.

Filter pending documents

  1. Open Add filters.
  2. Find Pending DMI and add Greater than 0.
  3. To restrict to the active book, add Status = Active with all criteria.
  4. Apply filter; verify conditions and total.

The illustrated example uses Pending DMI greater than zero and finds three fictitious policies. This is a policy count for that condition, not every kind of pending document or a count of documents.

Pending DMI greater than zero in the Policies filter.
Pending DMI greater than zero in the Policies filter. Open the image to enlarge it.
Three fictitious policies in the pending-DMI scope.
Three fictitious policies in the pending-DMI scope. Open the image to enlarge it.

Combine dates and conditions deliberately

All criteria means Active AND Health must both match. Any criterion means Active OR Health and also includes other active lines and Health policies in other statuses.

For October applications, filter Application date between October 1 and 31, 2026. For renewals, use Expiration date and the desired range. Effective date and creation are different events. Grouping by month does not itself restrict the date range.

Where supported, select multiple options with Any of. Plan year supports comma-separated years with that operator. Review the condition summary before applying.

Sort, paginate and open records

  1. Choose Sort records by and ascending or descending in the builder.
  2. Click sortable table headers to change direction.
  3. Check total and range; choose 10, 25, 50 or 100 per page.
  4. Use Open record to inspect the policy before following up.

Pagination does not change the filtered universe. A Table can have one optional chart grouping while retaining individual rows; the chart covers the whole filtered set.

Separate temporary filters from saved settings

Filters in a saved report changes that consultation. Applied conditions affect table, totals, chart, drill-down and export and return to page 1. Cancel discards uncommitted filter changes.

Clearing temporary filters shows all 12 fictitious policies in the image. Reopening restores the saved definition and three pending records. To persist a change, use Edit, adjust the builder and save. Clearing filters does not delete records.

Temporary consultation without the pending filter, showing 12 policies.
Temporary consultation without the pending filter, showing 12 policies. Open the image to enlarge it.

Keep learning

Updated October 25, 2026.