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.
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.
Add Child: Add a child report (subreport) of 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.
Columns tab
Name: Name of the column.
Format: Format of the column. If specified, must use the Java MessageFormat formatting syntax. For detailed information and examples, see the Sun Javadoc information for the MessageFormat class in the java.text package.
hAlign: Horizontal alignment: Left or Right
vAlign: Vertical alignment: Bottom, Center, or Top
Add Column: Adds a new column.
Remove column: Removes the selected column.
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