Calibration Manager Frequently Asked Questions - 2.x

• Backup
• Errors Opening a Database
• Due Dates
• Installation
• Printing & Exporting Reports
• Designing Reports
• Upgrading Data from version 1.x to version 2.x

Backup back to top

Q: What files should I be backing up?
A: Files that should be backed up are:

1. SETUP.SDB
2. SECURITY.SDB
3. BMS.MDW
4. Your database (E.g. USERDATA.CAL) LOGS (subdirectory under data) and
5. LOGS subdirectory under your *.CAL file (if not stored in the data directory)
6. Your Reports directory

Errors Opening a Database back to top

Q: When trying to open my database I receive a message "The database is not registered for use with the current System Databases."
A: The date/time stamp in the database does not match the date/time stamp of the System Databases. Run Calibration Manager Database Integrity.

Q: I keep getting a "Not Registered" message when trying to open a new database.
A: New databases can be registered to the appropriate system databases by following these steps:

1. From the Windows Start menu select Programs|Calibration Manager.
2. Click on the Calibration Manager Database Integrity listing.
3. Click Add and browse to the drive/directory where the database (.cal) file is located then double-click on the file.
4. Click Start to begin the Integrity process.
5. When the "Verification Complete" click Close.
6. Start Calibration Manager and you will be able to open the new database.

Q: After upgrading my DOS data I get a "Not Registered" message every time I try to open the database, and Database Integrity doesn't fix it.
A: During the upgrade one of the system databases got a "hidden" character stuck in the Validity (Registration) table. Contact Technical Support to request the Techutil.exe file. This file will completely clear the Validity table in the database, thus allowing Database Integrity to appropriately "register" all files.

Due Dates back to top

Q: Why are my Due Dates not being updated in the Equipment Master after adding a history?
A: Due dates typically are not updated for an event when the Event Name was not specified in the Add History window during the addition of the history, or when the history was saved the Update Due Dates option was not selected.

Q: Why do I have a wrong/out-of-date Due Date in my History records?
Q: Why is the Due Date in my History record different from the Due Date in my Equipment Master record?
A: You should only refer to the Due Date field on the Equipment Master record to see when an event is due. The Due Date in a History record is for historical/tracking purposes, and does not reflect the current/pending due date for a piece of equipment. Think of a History record as a snapshot in time. If you enter a History record for an event that was due on 4/1/1999, the History record will always show that this particular event was due on 4/1/1999. This allows you to track whether or not past events have been performed on time or not.

Installation back to top

Q: Is Calibration Manager 2.x compatible with Windows 2000 and Windows Millennium Edition?
A: Calibration Manager 2.x is NOT compatible with Windows 2000, even though it may appear to install successfully. If you wish to run Calibration Manager under Windows 2000, you will need to upgrade to version 3.x or above. Calibration Manager 2.x is compatible with Windows Millennium Edition

Q: What do I need to know about installing Calibration Manager on a Windows NT workstation?
A: When installing on Windows NT workstation the user must have administrative rights to that workstation.

Q: When trying to start the Crystal Reports Designer I get the following message: "Could not find Crystal Reports. Press "OK" to specify location."
A: This message will only come up the first time you start Crystal Reports after installation. Select the drive/directory where Crystal Reports was installed. Make sure that Crystal Reports was installed.

Q: When starting the 32-bit version of Crystal Reports Designer I get an I/O error.
A: Table may have been damaged and must be recreated. Delete the CRW.CRR file from the Crystal Report directory. The next time you start Crystal Reports a registration screen will be shown. Fill out the appropriate information. Enter 2133540163 for the Serial Number and select Done when complete.

Printing and Exporting Reports back to top

Q: When I print my reports using a Select/Sort, the data is not sorting as I specified.
A: It is possible to apply a Calibration Manager Select to a report, but the reports will not recognize a Calibration Manager Sort. If you want to change the Sort order of a report, you must do so in design mode using Crystal Reports. For more information please refer to Chapter 9, in the section "Modifying Existing Reports and Templates".

Q: Can Calibration Manager export data and if so where can I find out more about Exporting?
A: Calibration Manager is capable of exporting report data to a number of different formats, including Excel, Word, HTML, and more. See Chapter 9 of the Calibration Manager Users Manual for more information.

Q: When printing a report I receive Error from PEStartPrintJob: 536 ­ Unable to connect: incorrect log on parameters.
A: The ODBC connection did not get setup properly during installation. Version 2.0 ­ 2.1 users: Perform a Custom installation with only the ODBC Configuration option selected. Version 2.11 users: Run the 16(or 32)-bit INI and ODBC Reconfigure program in the Calibration Manager program. Which Utility to run is determined by which version of Crystal Reports Designer has been installed.

To determine which version of Crystal Reports has been installed:

1. Select Design from the Reports menu
2. Once Crystal Reports Designer has been launched select About Crystal Reports for Calibration Manager from the Crystal Reports Help menu.
3. The second line of this screen will tell you which Crystal version you have installed.
   16-Bit = Product 5, 0, 0, 108 CRW 5, 0, 0, 108
   32-Bit = Product 5, 0, 0, 108 CRW32 5, 0, 0, 108

Q: When I print my report I do not get all of the records in the system in the print out.
A: Check the select criteria used in Calibration Manager and/or the report design. A common source of this problem is the Status Criteria in the report design.

Designing Reports back to top

Q: How do I show field labels in the design of a report when all I see are x¹s?
A: Follow the steps listed below to display field labels in the design of a report:

1. Start Crystal Reports Design.
2. Select "Options" from the File menu.
3. Select the option "Show Field Names" from the Field Options Group.

Q: I keep getting one page per Event/Set Point in a tabular Report.
A: The report may contain a field(s) from the EM or EH recordset in the details section of the report causing the report to break after each Event or Measurement Set point. Moving the field(s) out of the detail section of the report should correct the problem.

Q: How do I convert report fields that display scientific notation in preview to standard numbers?
A: To translate Pre-Deviation and Post-Deviation measurement fields to a real number instead of Scientific Notation, create the following formulas:

1. Select Insert|Formula Field
2. Click New
3. Enter the name: PreCal to Number
4. In the Formula Text field enter: ToNumber ({Measurement.Pre-Calibration})
5. Click Accept
6. Click New
7. Enter the name: Meas Setpt to Number
8. In the Formula Text field enter: ToNumber ({Measurement.Setpoint})
9. Click Accept
10. Click New
11. Enter the name: PreCal Dev to Number
12. In the Formula Text field enter: {@PreCal to Number} - {@Meas Setpt to Number}
13. When inserting "PreDeviation", instead of Selecting Insert|Database Field to place the field on the report design, select Insert|Formula Field and insert "PreCal Dev to Number".
14. Select Insert|Formula Field
15. Click New
16. Enter the name: PostCal to Number
17. In the Formula Text field enter: ToNumber ({Measurement.Post-Calibration})
18. Click Accept
19. Click New
20. Enter the name: PostCal Dev to Number
21. In the Formula Text field enter: {@PostCal to Number} - {@Meas Setpt to Number}
22. When inserting "PostDeviation", instead of Selecting Insert|Database Field to place the field on the report design, select Insert|Formula Field and insert "PostCal Dev to Number".

EXTRA BONUS:
To have a field print "None" when the data field is blank, create the following formula:

1. Select Insert|Formula Field
2. Click New
3. Enter the name: e.g.: SerialNum to None
4. In the Formula Text field enter: if Length (Trim ({Equipment.Serial Number}))=0 then "None" else {Equipment.Serial Number}
5. Click Accept 6. Instead of Selecting Insert|Database Field to place the field on the report design, select Insert|Formula Field and insert "SerialNum to None".

Q: How do I stop my report from double spacing my details section?
A: The double spacing effect comes from extra white space in the details section of the report. To remove the extra space decrease the size of the details section.

Q: How do I get my report to stop printing a second blank page?
A: Try decreasing the size of the detail section of the report. When the total size of all report sections is larger than the page dimensions, this effect can occur.

Q: When I print my log reports I get data from a different Database.
A: The database log location is set to use a different database and needs to be set to use the current database. Directions to set the database in the report can be found in Chapter 8 of the Calibration Users Manual under the topic "External Logs" How do I change my report from portrait to landscape? The steps listed below will set a report to print in landscape mode: Open the report to be changed in Crystal Reports Designer. From the File menu select Printer Setup. When the Printer Setup Dialog is shown, change the Orientation to Landscape and click OK. Save the Report.

Q: Where is the Crystal Reports Manual?
A: The Crystal Reports Manual can be found on the Calibration Manager CD in the CRW directory under the File Name CRYSTAL.PDF. (Note: This file can be opened using the ACROBAT READER program shipped with Calibration Manager.).

Q: Why can't I read the bar codes I printed on my forms?
A: Crystal Reports does not include fully functional bar code fonts with their software. If you wish to print bar codes, you must purchase the fonts from a distributor specializing in bar code fonts. Here are a few you may wish to contact:

• Rivers Edge, PO Box 2528, Cedar Park, Texas 78630-2528, USA Phone: (512) 219-7768, Fax: (512) 219-7769, http://www.riversedge.com/
• Azalea Software, Inc., 219 2st Ave. S., Suite 410, Seattle, WA 98104-2575, USA Phone: (206) 341-9500 or (800) 48-ASOFT, Fax: (206) 341-9881, http://www.azalea.com/

Upgrading Data from version 1.x to version 2.x back to top

Q: When upgrading my DOS data the system locks up.
A: Are you trying to place your upgraded data into the root directory of a hard drive? The upgrade program will not allow you to place databases into the root directory of you hard drive. You must specify a directory and file name. For example: C:\CALMAN2\DATA\NEWDATA.CAL

Q: When upgrading my DOS data I receive a message "The specified Calibration Manager 1.x directory does not contain all of the files needed.
A: Please select a different directory." Did you specify the correct location of your Calibration Manager™ 1.x data? You must tell the Upgrade program where your Calibration Manager 1.x data is currently located. For example C:\CALMAN The minimum Calibration Manager 1.x files that are required by the Upgrade program are the *.DBF and *.SET files.

Q: When upgrading my DOS data I receive a message "The file name for the new database is invalid.
A: Please enter a valid file name." You have to tell the Upgrade program where to place your upgraded data and also the name of the database for the upgraded data. For example: Wrong Entry: C:\CALMAN2\DATA Correct Entry: C:\CALMAN2\DATA\NEWDATA.CAL

Q: When I try to start Calibration Manager for Windows after completing the upgrade of my DOS data I receive a message: "Invalid Password" when trying to log in to the system.
A: Try entering your Calibration Manager 1.x User ID as the password also. Try entering User ID = Admin, Password = Admin. ** It was not possible to upgrade the encrypted passwords you used with the Calibration Manager™ 1.x program. If neither if these options work you can:

• Delete the newly created database, then remove all security from the DOS version of Calibration Manager and rerun the upgrade.
• Have the Contact Person (the person that received the software) call us for assistance.

NOTE: We are no longer supporting Calibration Manager 2.x via phone, fax or email.