How do I count records?
There's an option to count the number of records, count the number of records with a value listed in the column, or count both the number of records and the number of records with a value.
Counting records
1. Open a report.
2. Click to select the Columns tab.
3. Use the Section menu to select the report section that will contain the new report line.
4. Click to select a column.
The column properties display on the Column subtab.
5. Find the section titled Count.
6. Click to select the checkbox titled Count.
7. Use the Count menu to select Records.
Connect will count the number of records in the column.
Counting records with values
1. Open a report.
2. Click to select the Columns tab.
3. Use the Section menu to select the report section that will contain the new report line.
4. Click to select a column.
The column properties display on the Column subtab.
5. Find the section titled Count.
6. Click to select the checkbox titled Count.
7. Use the Count menu to select Values.
Connect will count the number of records that have a value in the column.
Counting records and records with values
1. Open a report.
2. Click to select the Columns tab.
3. Use the Section menu to select the report section that will contain the new report line.
4. Click to select a column.
The column properties display on the Column subtab.
5. Find the section titled Count.
6. Click to select the checkbox titled Count.
7. Use the Count menu to select Both.
Connect will count the number of records in the column AND the number of records that have a value in the column.
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
How do I delete orphan records?
When tracking history is deleted, you may have orphan records. An orphan record is created when deleting tracking history (like logs or history) may leave behind related data that no longer has a parent or reference, in other words, pieces of ...How do I delete terminated employee records?
How do I delete terminated employee records? Remove terminated employees from Payroll. When an employee’s record is no longer required, you can delete the entire record, including summary records, from Payroll. Use Delete Inactive Employees to delete ...How do I find and link contact records?
If you have been using Caselle Connect and you want to start using the Master Contacts list in System Management, you should run Find and Link Related Records. Find and Link Related Records will search the existing database for matching records to ...How do I look for terminated employee records with issues?
In some situations, an organization may want to delete terminated employee records from the Payroll database. An employee record cannot be deleted, if the date when the employee was terminated is less than the current payroll year minus the number of ...How do I recalculate employee/employer summary records?
Recalculate the employee/employer summary records that Payroll will use to calculate pay code limits. In some circumstances, the pay code or employee/employer pay code may use the wrong calculation formula to calculate pay code limits. To fix the ...