Create/Edit User Defined Report

The following information applies to a user-defined report. You can create a simple report based on a SQL query or, if you click Advanced, a report with specialized features such as a child report. For information about how to create a user-defined report, as well as examples of creating such reports, see User Defined reports.

Advanced: If this option is not checked, the box contains basic information and the Property subtab. If this option is checked, the box also contains subtabs for SQL Query, Child Reports, Binds, Frill Down, and PDF.

Database connection dropdown: Select the database connection to use for the report.

Style: The style or type of report:

You are encouraged to experiment with different style options to see which best meets your needs.

Description: Optional description of the report.

Tool Tip: Popup text that will be displayed when you hover over the report name in the Reports navigator.

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

SQL: Area for entering the SQL query for the report. You can use the folder icon to select a file with the SQL text, and the eraser icon to erase the contents of the SQL box.

SQL Query (advanced)

Area for entering the SQL query for the report. You can use the folder icon to select a file with the SQL text, and the eraser icon to erase the contents of the SQL box.

SQL Variants: Lets you add and remove Minimum Version and Maximum Version information.

Child Reports (advanced)

Lets you add and remove child reports to a master report.

For an example of creating a child report (where you can click a department ID in the top part to display employees in that department in the bottom part), go to the Start Page (Help > Start Page). On the Get Started tab under Featured Online Demonstrations, and click Reporting Features. On the displayed page, find the title containing Adding a Child Report.

Add Child: Lets you specify the name of the child report, after which a node is added for that child report, along with SQL Query, Property, and PDF subtabs for the child report.

Binds (advanced)

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.

Drill Down (advanced)

You can click Add Report to specify one or more reports to be enabled for drill-down display. To remove a report from drill-down, select it and click Remove Report.

Property

Displays options relevant to the Style (report type) that you selected. (Relevant for Table, Chart, and Gauge styles.)

PDF (advanced)

Lets you specify layout and formatting options for when the report is exported as PDF. For example, you can specify a header and footer; security options including password-protection, encryption, and restrictions on printing and copying; and page layout options such as margin sizes and portrait or landscape orientation.

Related Topics

SQL Developer Reports

User Defined reports

Gauges: In the SQL Worksheet and User-Defined Reports