Table 2 discusses some problems you may encounter when troubleshooting Production Reporting LOCAL functions and suggested solutions to the problems.
Table 2. Situations and Solutions for Troubleshooting Production Reporting LOCAL Functions
Situation | Solution |
|---|---|
LocalRun fails, SQR.DLL is not found. | Either SQR.INI is not found in the system directory, or the directory pointed to by SQRDIR in the SQR.INI section [Environment:DatabaseName] does not contain SQR.DLL. Reinstall Production Reporting, and ensure that SQR.INI is in the system directory (such as C:\WINNT) and is updated correctly. |
LocalRunNoWait fails. | Either SQR.INI is not found in the system directory, or the directory pointed to by SQRDIR in the SQR.INI section [Environment:DatabaseName] does not contain SQR.EXE. Reinstall Production Reporting for Windows, and ensure that SQR.INI is in the system directory (such as C:\WINNT) and updated correctly. |
When running LocalRun or LocalRunNoWait, the Production Reporting start up dialog box appears. | This occurs because the command line arguments passed to these function calls are not complete. The first two elements must be the Production Reporting program filename and a connection string. If the Production Reporting program does not involve database manipulation or access, use a slash (/) as a placeholder for the connection string, and specify the ‑xl flag. |