Creating Custom Reports

This feature is available in Workflow Manager only.

You can create the following types of custom reports using the Reports Wizard:

• Custom Report—A custom report defined by using the Reports Wizard. See Creating a Custom Report.

• Activity Report—A custom report, which you define using the Report Wizard, that displays a listing of activities that occur during the completion of a request. See Creating an Activity Report.

• Custom SQL Query Report—A custom report defined by entering an SQL query in the Report Wizard. See Generating a Custom SQL Query Report.

• Custom Stored Procedure Report—A custom report defined by specifying a stored procedure in the Report Wizard. See Generating a Custom Stored Procedure Report .

Additional information is provided in this section that may help you generate custom reports:

• Wildcard Support in Reports SQL Queries—You can combine the SQL LIKE operator with wildcard characters to perform searches. See Wildcard Support in Reports SQL Queries.

• Sample SQL Queries Used to Generate Project and Workflow Request Reports—Sample SQL queries that are used to generate the built-in Project and Workflow Requests reports are provided. These sample queries might be helpful to refer to when you are creating your own custom reports. See Sample SQL Queries Used to Generate Project and Workflow Request Reports.