Creating A New Report Definition
1. Invoke Oracle Reports Builder and connect to the Oracle. Click on the Tools..Report Wizard… for create new report.
2. Select Group Left as a presentation Style as shown.
3. Enter the SQL statement as in the Data Tab. The SQL statement is as given below:
4. Group Left report requires the name of the column that must be used as a break column. In the current example, the is repeating as the multiple items are selected for every order. Thus the break column must be set to………..
5. empno is displayed in the group field list as shown….
6. The list of columns that must be displayed on the report is asked for. Click on to select all the columns.
7. The totals and calculation page is displayed next. Since the totals are not required for the selected columns, click on text.
8. The Labels page is displayed next.
9. The Templates screen is then displayed. Select ‘Cyan Grid’ presentation style and click on Finish. A default tabular report with a group break on empno is displayed…..
About Repeating Frames:
Repeating frames contain data owned through their corresponding groups. The Repeating frames are called so because repeating frames are repeated as several times as necessary to show all the records.