Specifying the Data and Layout for the Report:

1. After invoking the connecting to the database and Report Builder, the next step is to specify the data for the report. For that Click on Tools...Report Wizard… to begin the report wizard for a new report. A Report Wizard displays a number of Tab pages to enter information needed for report creation. The various tab pages are as follows:

•  Style                 • Totals
•  Data                  • Labels
•  Fields                • Template

2.Any report created using Report Builder needs a query through that data will be retrieved for the report. The Data Tab permits creation of an SQL statement using Query Builder. The SQL statement could also be entered in the multi line edit box given in the data tab.

This select will really get the data of the report from a base table. The finished query property sheet will be as displayed.

3.Fields Tab is used to specify the fields which must be displayed in tabular format. Select all fields through clicking on the icon. Completed screen will be as displayed in following diagram.

4.Click on Next. The Totals tab is displayed that allows creation of summary columns using aggregate functions. This report does not involves totals for the selected fields and therefore click on Next.

5.The Labels for the columns can be modified using the Labels tab. modify the Label of Sum_Quantity column to Quantity    and Avg_Product _Rate to Avg.  Rate.  The completed screen will be displayed as shown.

6.Report can be created from templates. There are several of pre-determined templates available in Oracle Reports Builder. Reports are by default created using pre- determined template named Corporate 1 as displayed.

7.Reports Builder involves a Live Previewer which is used to display the report when the Finish button is clicked; the Report Runtime is invoked as shown.

8.Reports  created  in  Report  Builder  could  also  be  displayed  in  the  Reports  Runtime Window. Then Click on View...Runtime Preview. Report Runtime is displayed as displays.

9.Close Report Runtime Previewer through clicking on icon. Then Click on View...Data Model to open the Data Model editor. A Data model editor displays a query object named Q_1 and a group object named as G_description and data column selected by using an SQL Select statement. A query object and the group object must be renamed suitably.

Right click on query object and select Property Palette from the popup menu. Set the Name property to radiant. Likewise right click on group object and select Property Palette from the popup menu then Set the Name property of the group object to radiant. The completed data model editor is display given below.

10.Click on File...Save to save the report. Indicate the report name as radiant.rdf and specify the path for the report file and click on OK.

The report file would be saved with the specified named.