CMS Contributions - Consecutive Absence or Attendance Pattern Report Fails to Print

PROBLEM: When attempting to print the Consecutive Absence Report (From CMS Attendance, click Reports | Consecutive Absence) or the Attendance Pattern Report (From CMS Attendance, click Reports | Attendance Pattern), the report is missing some or all of the members normally included on the report.

SOLUTION: From CMS for Windows, click File | Utilities | CMS Table Repair.

On the Table Repair Utility Screen, click Browse in the upper right corner. Find the table ATDETAIL.DB and click Open.

Jot down the Number of Records, located about half way down the left side of the screen. You'll need that number in a few seconds.

Click the Verify Button at the bottom of the screen. It will come back with either "Table and Header Verify Okay" or "Table Requires a Rebuild". Jot down this message and click OK.

Click the Rebuild Button at the bottom of the screen. When complete, it will come back with a Number of Records Successfully Recovered. That number should match the number you jotted down previously. Click OK | OK.

Repeat these steps with the following tables:

ATDETAIL.DB
ATCONSEC.DB
PERINGRP.DB
PERSON.DB
PRIV: ALLDATES.DB
PRIV: AVAIL.DB
PRIV: CANTBL.DB
PRIV: DATELIST.DB
PRIV: SELECTED.DB
PRIV: SELPERSN.DB

Now with the few last tables, at the bottom of the Browse button, you'll see Alias : WORK. Click the little down arrow next to WORK and choose PRIV. Now find the table ALLDATES.DB and continue with the steps to rebuild it.  Repeat with the remaining tables.

Once all of these tables are rebuilt, go back into the Attendance System and click Reports | Consecutive Absence or Attendance Pattern and reprint your report!

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.