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 ...Report Column Totals
When you set up a report, the report organizes the report data into report columns. You can change the properties on a report column to insert a total. The total option on a report column can add the values, count the number of records, count the ...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 update changes to employee records?
After you make changes to the shift schedule, the next step is to copy the shift schedule to the employee records that are assigned to the shift. All of the changes that you make to a shift schedule must be updated manually. Updating changes to ...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 ...