Creating a task to Create Custom SQL Reports

About this task

Use this task to define your own reports by writing or importing SQL queries for extracting data in HTML or CSV format. To create an SQL report task, perform the following steps:

Procedure

  1. From the navigation toolbar, click Reporting > Create Custom SQL Reports, and click New.
  2. In the Create Task panel, select Report Definition > Custom SQL Report Task > Next.
  3. In the Enter Task Information panel, define the type of scheduler engine here you want to run the task. You can select an engine at a later time. Remember that the engine name must be specified before running the task. Depending on the engine type you choose, the filtering criteria and the results you can display are different. You can also specify whether to share the task with others, to allow them to see and run the task, but not to modify it. Task and engine sharing can be disabled by the TWSWEBUIAdministrator in the global settings customizable file.
  4. In the Report Header panel, choose the name and the format of the output of the report and click Next to proceed or Finish to complete the task creation using all the default values. The Custom SQL Report supports only the Tables View in either HTML or CSV format.
  5. In the Filter Criteria panel, enter the SQL statement on which you want to base your report. You can write the query in the text pane or load an existing query from a file by browsing to the required file and clicking Load. Click Next to proceed or Finish to complete the task creation using all the default values.
  6. In the Report Output Content panel, select the job information that you want to display in the report output. After you make your selection click Next to proceed or Finish to complete the task creation using all the default values.
  7. In the Create New Task panel:
    • Select Run this Task Now and click Finish if you want to run the report task. If you have not yet specified an engine connection, you are prompted to do so now.
    • Click Cancel to exit without saving your changes.
    • Click Finish to save the task, without starting it immediately.

Results

You have created your task that, when run, creates a report satisfying your filtering criteria and showing the information you selected to view.