Page tree

Problem


When trying to print Report Cards, this error displays

"Cannot generate report, no SQL."


Products Affected: HeadMaster Pro

Versions Affected: Multiple Versions

Solution


If the report that displays error is a copied report, try printing the default. If no error on displays the default report, try making a copy of the report.

If the error still occurs, repair the HeadMaster tables.

Repairing Tables

 Many issues contribute to data corruption, from power surges and network issues to hardware failure. If your data is corrupt, you can repair the tables in HeadMaster.

Since repairing tables can result in data loss, be sure everyone in your organization exits HeadMaster, then perform a backup. 

 To perform a HeadMaster backup
Make sure everyone is logged out of HeadMaster before performing the backup.

To back up HeadMaster data:

  1. Open the Utility Manager.
  2. Click Create Backup. The Database Utilities dialog box displays.
  3. Make your selections and click Backup.
  4. Click OK.

 

 To repair HeadMaster tables
  1. Open the Utility Manager.
    a.) Windows 7 and Windows Vista: On your Windows desktop, click the Start button  in the lower-left corner of the screen. The Start menu displays. Click All Programs > HeadMaster > Utility Manager. Log in with your user name and password, and click OK. The Database Utilities window displays.
    b.) Windows 8.1: On the Windows desktop, click the Start button  in the lower-left corner of the screen. The Start screen displays. Click the arrow button . The Apps view displays. In the HeadMaster section, click Utility Manager. Log in with your user name and password, and click OK. The Database Utilities window displays.
    c.) Windows 10: On the Windows desktop, click the Start button  in the lower-left corner of the screen. The Start menu displays. Scroll to the HeadMaster section, and click Utility Manager. Log in with your user name and password, and click OK. The Database Utilities window displays.

    Link
  2. Click Table Maintenance.
  3. Under Connection Settings, select the correct data set, and click Repair All Tables.
  4. Select the System data set, and click Repair All Tables.
  5. Click Close.