Adding Custom Scripts to System Reports/Queries

System administrators can execute custom SQL scripts by first setting up report specifications. The benefit of executing a SQL script in this method is that the script can be automated from the iMIS front-end and report driven.

  1. Select Utilities > Report Specs.
  2. Select a report from the SYSTEM-System Setup group to clone.
  3. Click the Clone button.
  4. Enter a System, Category, Title and Description.
  5. Click the Parameters button.
  6. Enter SQLExec/240 in the Control Procedure box.
  7. Enter MUST_BE_DBO,SHOW_SQL in the Options box.
  8. Substitute the script in the Parameters box on the Detail Report Parameters window

    9. Note: Place your cursor in the Parameters box and press CTRL+Z or click the Zoom button to open the parameters window.

  9. Click OK to accept the changes. You can now execute the script from the Utilities > Reports & Queries window from within iMIS.
  10. Click Run to execute the command. iMIS prompts you to confirm the action Updates Functional Title.
  11. Click Yes to execute the script.

Example: Select a Report from the SYSTEM-System Setup.

Example: Enter MUST_BE_DBO,SHOW_SQL in the Options box.

Example: Substitute the script in the Parameters box.

Example: You can now execute the script.