Create/Edit User Defined Report

The following information applies to a user-defined report. For information about how to create a user-defined report, as well as examples of creating such reports, see User Defined reports.

Add Child: Add a child report in this report.

Test: Tests the report definition by running it in a separate window. This feature enables you to test the report before creating it.

Details tab

Name: Name of the user-defined report.

Style: Report style: Table (default), Code (formats the code in the output), Chart (bar or pie chart; see User-Defined Report Example: Chart for an example), Gauge (dial or status meter; see Gauges: In the SQL Worksheet and User-Defined Reports), plsql-dbms_output (dynamic HTML; see User-Defined Report Example: Dynamic HTML for an example), or Script (executable script).

Description: Optional description of the report.

ToolTip: Optional tooltip text to be displayed when the mouse pointer stays briefly over the report name in the Reports navigator display.

SQL Statement: The complete SQL statement for retrieving the information to be displayed in the user-defined report. As a trivial example, the statement SELECT user "Current User" FROM DUAL displays Current User as the heading and the name of the user associated with the current database connection.

Suggestion: Look at the SQL statements for various SQL Developer-supplied reports; check the Messages - Log pane below the report results, or click the SQL icon under the Report Results tab.

Binds tab

Name: Name of the bind variable.

Prompt: String displayed when the user is prompted to enter a value. Example: Table name

Default: Default value if the user does not enter a value at the prompt. To accept the Oracle SQL value, specify NULL_VALUE.

ToolTip: Optional tooltip text to be displayed when the mouse pointer stays briefly over the bind variable name.

Chart Details tab

Available if the report type is Chart.

Chart Type: Bar chart with horizontal or vertical bars, or pie chart.

3D Graph: True for a three-dimensional appearance; False for a two-dimensional appearance.

Gradient Effect: True for a gradient effect; False for no gradient effect.

Chart Style: Thematic name for the overall appearance of the chart.

Show Grid: True to show the grid lines; False to hide the grid lines.

Show Legend: True to show the chart legend; False to hide the chart legend.

Gauge Details tab

Available if the report type is Gauge.

Gauge Type: Dial (like a fuel gauge in an automobile) or Status meter (bar representation).

Query Based: True if the minimum, maximum, low, and high values are specified in the SQL query; False to specify the minimum, maximum, low, and high values in the remaining fields.

Min: Minimum value displayed on the gauge.

Max: Maximum value displayed on the gauge.

Low: "Low" value; usually greater than Min and less than High.

High: "High" value; usually greater than Low and less than Max.

Related Topics

SQL Developer Reports

User Defined reports

Gauges: In the SQL Worksheet and User-Defined Reports