(301) 947-7380
99.987% uptime·0 security breaches·Since 1989·Built and supported in the U.S.
Posted November 19, 2026

The Fields step of a DAT Query now has a Show checkbox on every field row, so report builders choose which fields appear as columns in the results. A field with Show cleared keeps its place in the query, ready for calculated fields and grouping, and the results present just the columns each reader needs.

What can schools do with the Show checkbox?

Show a calculated field on its own. A calculated field such as Full Name, built as [First Name] + ' ' + [Last Name], appears as a single column once Show is cleared on First Name and Last Name.

Keep every record on its own row. A Group field such as Student Id can stay in the query with Show cleared, so two students who share a name each keep their own row while the results list names.

Send exports that match the screen. The Export file and DAT dashboards carry the same columns as the results.

Merge on any field. Print, Print to PDF and DataSource include fields with Show cleared, so mail merge templates can use every field in the query.

See the full field list while arranging columns. On DAT Column Order - Step 3, fields with Show cleared are listed in gray with "(hidden)" after their names.

How does the Show checkbox help report builders?

A registrar building a class list for teachers can show Full Name and Grade Level, keep Student Id in the query so each student holds a row, and send the Export with exactly the columns on screen. The same report still offers every field to a mail merge letter for families. Each choice is saved with the report, so everyone who runs it sees the same columns. For the steps, see DAT Fields - Step 2.

Questions schools ask

Does clearing Show change the numbers in a report? No. The field stays in the query, so calculated fields, grouping and totals work the same way with Show selected or cleared.

Can a mail merge template use a field with Show cleared? Yes. Print, Print to PDF and DataSource include it.

Where is the Show checkbox? On the Fields step (DAT > Queries > Fields), in the Show column of each field row. Every row starts with Show selected.

Available now to all PCR Educator schools. Your account team can walk you through the Show checkbox whenever you're ready.

PCR Educator
School Operations Platform

One platform for K-12 schools, higher education, performing arts institutions, and health science programs since 1989.

PCR Educator on Capterra: 4.7 out of 5 stars
Platform
    Solutions
      Resources
        Company
          © 1989-2026 PCR Educator, Inc.Silver Spring, MD · U.S.A. · (301) 947-7380