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.