Previous Topic

Next Topic

Book Contents

Book Index

Changing the page layout for a report

Use the following Change Layout menu selections to change the look and feel of an ad hoc report.

Change Layout menu selections

Option

Description

Chart button. Click to create a chart. Chart

Present information graphically using one of several 2D and 3D formats.

Chart button. Click to create a chart. Define Conditional Styles

Apply font styles depending on the data values in a column.

Chart button. Click to create a chart. Change Font Styles

Specify font types and sizes for a report.

Chart button. Click to create a chart. Change Border Styles

Specify the line weight and color for report borders.

Reset Font and Border Styles

Reset the report output to the default format.

Apply Template

Apply formatting that you create using Report Studio.

Edit Title area

Include meaningful report titles and optional subtitles.

Set Web Page Size

Specify the maximum number of rows of data that appear on any page of an ad hoc report.

Set Page Breaks

Specify page breaks on groups or report sections.

Group button. Groups duplicate data in a report. Group

Organize a report so that identical values in a column appear together and suppress the display of duplicate values.

  • The grouped column automatically sorts in ascending order.
  • Duplicate values are suppressed.
  • A summary is generated for each distinct group value.

Pivot button. Conversts a list report to a crosstab report. Pivot

Convert a list report to a crosstab report.

Ungroup button. Click to display all values in a report. Ungroup

Revert to showing all values in a column including duplicates.

Create section button. Click to create a section in a report. Create Sections

Organize a report into a distinct section for each unique value within a column.

Swap rows and columns button. Interchange rows and columns in a report. Swap Rows and Columns

Interchange rows and columns in a crosstab, a chart based on a crosstab, or both.

Collapse group button. Click to reduce the level of detail in a report. Collapse Group

Temporarily reduce progressive levels of detail to high-level summaries.

Expand group button. Click to increase the level of detail in a report. Expand Group

Restore temporary collapsed levels from a Collapse Group action to the full detail levels.

Copyright © 2014 Oracle and/or its affiliates. All rights reserved.