Skip Headers
Oracle® Fusion Middleware Oracle Reports Tutorial
11g Release 1 (11.1.1)

Part Number B32123-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

B Tool Palette and Toolbar Reference

This appendix contains descriptions of the buttons and tools in the Reports Builder tool palettes and toolbars.

B.1 Main Toolbar

The main toolbar is located at the top of the Reports Builder window, directly beneath the menu bar:

New button. Displays the New Report dialog box.

Description of open.gif follows
Description of the illustration open.gif

Open button. Displays the Open dialog box.

Description of save.gif follows
Description of the illustration save.gif

Save button. Saves the report. If you haven't saved the report before, the Save As dialog box displays.

Description of save.gif follows
Description of the illustration print.gif

Print button. Prints the paper report.

Description of mail.gif follows
Description of the illustration mail.gif

Mail button. Displays the Mail dialog box.

Description of connect.gif follows
Description of the illustration connect.gif

Connect button. Displays the Connect dialog box.

Description of cut.gif follows
Description of the illustration cut.gif

Cut button. Deletes the currently selected item and temporarily places it in the clipboard. Use Paste to paste the selected item.

Description of copy.gif follows
Description of the illustration copy.gif

Copy button. Temporarily places a copy of the selected item in the clipboard. Click the Paste button to paste the selected item.

Description of paste.gif follows
Description of the illustration paste.gif

Paste button. Pastes the item in the clipboard in current location of the cursor.

Description of undo.gif follows
Description of the illustration undo.gif

Undo button. Undoes the last action performed.

Description of redo.gif follows
Description of the illustration redo.gif

Redo button. Performs the last action again.

Description of runhtm.gif follows
Description of the illustration runhtm.gif

Run Web Layout button. Runs the current report to your Web browser.

Description of run_paper.gif follows
Description of the illustration run_paper.gif

Run Paper Layout button. Runs the current report to the Paper Design view in Reports Builder.

Description of help.gif follows
Description of the illustration help.gif

Help button. Displays the Oracle Reports online Help.

B.2 Data Model View Tool Palette

The Data Model view tool palette is a vertical group of tools located on the left-hand side of the Data Model view.

Description of dmtoolpalette_xg.gif follows
Description of the illustration dmtoolpalette.gif

Description of select.gif follows
Description of the illustration select.gif

Select tool. Deselects any selected tool to turn off the current tool.

Description of magnify.gif follows
Description of the illustration magnify.gif

Magnify tool. Zooms in the view on the clicked object. Use SHIFT + Magnify to zoom out.

Description of colsum.gif follows
Description of the illustration colsum.gif

Summary Column tool. Creates a summary column in the query.

Description of datlink.gif follows
Description of the illustration datlink.gif

Data Link tool. Creates a link between the columns in the queries.

Description of colf.gif follows
Description of the illustration colf.gif

Formula Column tool. Creates a formula column in the query.

Description of cross.gif follows
Description of the illustration cross.gif

Cross Product tool. Creates a matrix (cross-product) group.

Description of coltemp.gif follows
Description of the illustration coltemp.gif

Placeholder tool. Creates a placeholder column which you can modify later.

Description of sql.gif follows
Description of the illustration sql.gif

SQL Query tool. Displays the SQL Query Statement dialog box where you can enter a SQL query SELECT statement or use Query Builder to create a query.

Description of plsqlico.gif follows
Description of the illustration plsqlico.gif

Ref Cursor tool. Displays the PL/SQL Editor where you can type a ref cursor query.

Description of xml.gif follows
Description of the illustration xml.gif

XML Query tool. Displays the Define XML Query dialog box, where you can specify the XML data definition and data source.

Description of jdbc.gif follows
Description of the illustration jdbc.gif

JDBC Query tool. Displays the JDBC Query dialog box, where you can define the SQL or stored procedure to define the data for the query.

Description of textqry.gif follows
Description of the illustration textqry.gif

Text Query tool. Displays the Text Query dialog box, where you can specify a text data definition and data source.

Description of xprs.gif follows
Description of the illustration xprs.gif

Express Server Query tool. Displays the Express Server Query dialog box, where you can specify an Oracle Express data definition and data source.

B.3 Paper Layout View Tool Palette

The Paper Layout view tool palette is a vertical group of tools located on the left-hand side of the Paper Layout view.

Description of pltoolpalette.gif follows
Description of the illustration pltoolpalette.gif

Description of select.gif follows
Description of the illustration select.gif

Select tool. Deselects any selected tool to turn off the current tool.

Description of magnify.gif follows
Description of the illustration magnify.gif

Magnify tool. Zooms in the view on the clicked object. Use SHIFT + Magnify to zoom out.

Description of fmsel.gif follows
Description of the illustration fmsel.gif

Frame Select tool. Selects all objects within the selected frame or repeating frame, depending upon their explicit anchors (first click the tool, then the frame).

Description of reshape.gif follows
Description of the illustration reshape.gif

Reshape tool. Enables you to reshape the selected boilerplate object.

Description of text.gif follows
Description of the illustration text.gif

Text tool. Creates a boilerplate text object.

Description of rotate.gif follows
Description of the illustration rotate.gif

Rotate tool. Enables you to rotate the direction of the selected boilerplate object.

Description of line.gif follows
Description of the illustration line.gif

Line tool. Draws a line boilerplate object.

Description of rect.gif follows
Description of the illustration rect.gif

Rectangle tool. Draws a rectangle boilerplate object.

Description of arc.gif follows
Description of the illustration arc.gif

Arc tool. Draws an arc boilerplate image.

Description of roundrect.gif follows
Description of the illustration roundrect.gif

Rounded Rectangle tool. Draws a rounded rectangle boilerplate object.

Description of polyline.gif follows
Description of the illustration polyline.gif

Polyline tool. Draws an open multilined boilerplate object. Use your mouse to create the multiple lines.

Description of polygon.gif follows
Description of the illustration polygon.gif

Polygon tool. Draws a multisided boilerplate object. The object must be closed, unlike a polyline object.

Description of freehand.gif follows
Description of the illustration freehand.gif

Freehand tool. Draws a line where you drag your mouse.

Description of ellipse.gif follows
Description of the illustration ellipse.gif

Ellipse tool. Draws an ellipse boilerplate object.

Description of frame.gif follows
Description of the illustration frame.gif

Frame tool. Draws a frame.

Description of repframe.gif follows
Description of the illustration repframe.gif

Repeating Frame tool. Draws a repeating frame.

Description of graph.gif follows
Description of the illustration graph.gif

Graph tool. Displays the Graph Wizard so that you can to define a graph that will be inserted into your layout.

Description of field.gif follows
Description of the illustration field.gif

Field tool. Creates a field object.

Description of anchor.gif follows
Description of the illustration anchor.gif

Anchor tool. Creates an anchor between two objects in your layout.

Description of filelink.gif follows
Description of the illustration filelink.gif

File Link tool. Creates a link file object that you can use to link an external file to your report.

Description of repblk.gif follows
Description of the illustration repblk.gif

Report Block tool. Displays the Report Block wizard so that you can add a new report block to your layout.