1. Introduction
   
   
2. Requirements
   
   
3. Important Note for Customers Upgrading
   
   
4. Installing the Web Reports Module
   
   
5. Configuration
   • Configuring the Web Reports Administration Console
   • Configuring the IIS Session Timeout
   • Configuring the Report Scheduler Service Controller
   • Configuring the SupportDesk Setup Console
   • Report Settings
   • Navigator Reports
     
     
6. Running reports from SupportDesk
   
   
7. Using the Web Reports Module
   • Logging In
   • The Main Window
     • Quick Reports View
     • User Defined Reports View
     • Report Templates View
     • Report Scheduling View
   • Adding a New User-Defined Report
   • Loading a Report
   • Exporting a Report
   • Printing a Report
     
     
8. Scheduling Reports from the Web Reporting Module
   • Report Scheduling – Step by Step Instructions
     • Add Report
     • Configure Report
     • Specify Report Criteria
     • Specify Navigator (CMDB) Criteria
     • Schedule the Report
   • Editing, Deleting and Cloning Tasks
     
     
9. Scheduling Reports from the Setup Console
   
   
10. Customising the Web Reports Module
    
    
11. Modifying a Report’s SQL query
    
    
12. The Error Console
    
    
13. Crystal Reports Compatibility
    
    
14. Recent Report Additions

Modifying a Report's SQL query

Figure 13: Modifying a Report’s SQL Query

This feature is recommended for advanced users only and allows you to change the underlying query for a user-defined report by directly editing its SQL query string.

• Highlight the required report from the User-Defined Reports tab and press the Show SQL button on the right-hand side of the tab page.
  
  
• A separate window will appear containing the SQL query for the selected report.
  
  
• Modify the SQL as required and then press the Parse SQL button. This attempts to execute the SQL and ensures that the syntax is correctly formed before allowing you to save the modified query. If an error occurs with the SQL, you will be re-directed to the application error console. From here, you will be able to determine the exact cause of the error and correct it by pressing your browsers back button.
  
  
• Once the SQL query has been modified, press the Update SQL button to save your changes.
  
  
• Press the Close button to close the SQL editor window. The next time the specified report is run, the changes made to its SQL query will be used as the criteria for the report.