Shortcut Menu Commands

Cut

Removes the selected row/column from the report and places it in the Windows clipboard

Copy

Duplicates the selected row/column and places it in the Windows clipboard

Paste

Places the cut or copied row/column in the report

Delete

Removes the selected row/column from the report

Save as Row and Column Template

Save the selected row/columns as a row and column template, which is a reusable repository object

Insert Row and Column Template

Inserts a row and column template from the repository into a grid below a row or to the left of the selected column

Format

Opens the Format Cells dialog box from which you can format numbers, align text, modify font options, add border and shading, and replace text for the selected item in the grid

Conditional Format

Opens the Conditional Format dialog box through which you can apply conditional formatting. For more information, see Formatting Reports.

Insert Row/Column / Data

When selected, a data row/column is added to the report

Insert Row/Column / Formula

When selected, a formula row/column is added to the report

Insert Row/Column / Text

When selected, a text row/column is added to the report

Menu Command

Description

Dimension Layout

Displays the Dimension Layout dialog box where you can change dimensions for the pages, rows, and columns of a grid

Grid Point of View

Displays or hides the Grid Point of View bar

Grid Point of View Setup

Displays the Setup Grid Point of View dialog box where you select members for the Grid Point of View

Data Query Optimization Settings

Displays the Data Query Optimization Setting dialog box where you can suppress the rows on the database connection server or the report server, include or exclude the Oracle Essbase sparse command, and set the number of asymmetric columns to consolidate

Save

Saves the report

Print

Prints the report

Page Setup

Opens the Page Setup dialog box from which you can specify page setup options, including page, margins, and Report Designer workspace size

Print Preview

Displays each page as it looks when printed

Web Preview

Displays each page as it looks in Workspace

Summary

Opens the Report Summary dialog box from which you can view report summary information

Show Guidelines

Displays the guidelines in Report Designer workspace

Insert Object / Grid

Enables you to insert a grid

Insert Object / Text

Enables you to insert a text box in the report

Insert Object / Image

Enables you to insert an image in the report

Insert Object / Chart

Enables you to insert a chart in the report

Insert Object / Saved Object

Opens the Insert Saved Object dialog box, through which you can insert an object that is saved in Studio Explore

Save Object

Opens the Save Object dialog box through which you can save the selected object to the repository or a folder in the repository.

Delete

Removes the selected item from the report.

Horizontal Position on Form / None

This selection indicates no horizontal positioning for the selected object.

Horizontal Position on Form / Relative

Sets the horizontal positioning of the object relative to the positioning of other objects on the form.

Horizontal Position on Form / Left

Sets the horizontal positioning of the object to the left of the form.

Horizontal Position on Form / Center

Sets the horizontal positioning of the object to the center of the form.

Horizontal Position on Form / Right

Sets the horizontal positioning of the object to the right of the form

Vertical Position on Form / None

This selection indicates no vertical positioning for the selected object.

Vertical Position on Form / Relative

Sets the vertical positioning of the object relative to the positioning of other objects on the form.

Vertical Position on Form / Top

Sets the vertical positioning of the object to the top of the form

Vertical Position on Form / Middle

Sets the vertical positioning of the object to the middle of the form

Vertical Position on Form / Bottom

Sets the vertical positioning of the object to the bottom of the form

Bring to Front

When organizing report objects, select Bring to Front to move an object in front of another object

Send to Back

When organizing report objects, select Send to Back to rearrange other report objects on top of, or in front of, the selected object

Zoom

When working with grids, select Zoom to expand the view of a grid to the size of Report Designer Workspace

New Folder

Adds a folder to the Studio Explore

Open

Opens a report, snapshot report, or report object into the Designer

Print

Opens the Print dialog box where you can print the selected report from the repository

Print Preview

Displays the report as it looks when printed

Web Preview

Displays the report in web preview.

Delete

Removes the selected file from the repository on confirmation

Display Items of Type / All Items

FromReporting Studio. When selected, all files are displayed

Display Items of Type / Report

From Reporting Studio. When selected, only report files are displayed

Display Items of Type / Snapshot

From Reporting Studio. When selected, only snapshot files are displayed

Display Items of Type / Saved Report Object

From Reporting Studio. When selected, only saved report objects (for example, images) are displayed

Refresh

Refreshes the repository to include new folders and reports

Format

Opens the Format Cells dialog box from which you can format numbers, align text, modify font options, add borders and shading, and replace text for the selected item in the grid

Conditional Format...

Opens the Conditional Format dialog box through which you can apply conditional formatting. For more information, see Formatting Reports.

Merge

Combines two or more cells into one cell in a grid