Oracle Reports Material Part 3

THE FOLLOWING WIZARD PAGES/SCREENS ARE APPEARED WHEN WE CREATING THE REPORT.

SCREEN-1

When you choose the Tabular style of report,  the wizard steps you through the Following pages:

Page Name

ü  Type:- Select the query type on which you want to base your report.

ü  Data :-Enter a SELECT statement to retrieve the report data.

ü  Fields:- Select the fields that you want to display in the output.

ü  Totals:- Select the fields that you want to summarize.

ü  Labels:-Alter the labels that appear for each field and the width of each field.

ü  Template:-Select the template that you want to use for this report. A template contains standard information such as company logo, date, and so on.

SCREEN-2

Note :- Title will display in the margin area of the report and title is optional.

SCREEN-3

SCREEN-4

SCREEN-5

   

Summaries and Labels

The next two pages of the Report wizard allow you to create summaries based on any

of the displayed fields and to modify the labels and width of the displayed fields.

v  Summaries : - If you choose a summary, the wizard creates the summary at each level of the report; that is, at report level and also at each break level, if your report contains break groups. You can deselect some of these summaries later. (by reentering the wizard)

SCREEN-6

 

Labels : - The field label is displayed on one or more lines in the report output. In a

tabular report, the labels appear above the field values.

ü  If the initial label is wider than the field, Report Builder allows enough space for

the label, or displays it on multiple lines.

ü  If you increase the number of characters in the label text in the reentrant wizard,

the label may appear truncated in the report output.

SCREEN-7

Choosing a Report Template

ü  Choose a template from the list of predefined template names.

ü  In a template, fonts, styles, and colors are already selected for designated objects.