|Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)
Part Number B32122-01
The steps in this section show you how to use the Report Block Wizard to create the layout and choose how your data will display in your report. Here, you will choose the style of report you want to create, and choose to display the data across the report (hence creating the across group report).
To create the default layout:
In the Object Navigator, double-click the Paper Layout node to display the Paper Layout view.
In the Paper Layout view, choose Insert > Report Block to display the Report Block Wizard.
In the Report Block Wizard, on the Style page, select Group Above, then click Next.
On the Groups page:
Click G_LAST_NAME in the Available Groups list, then click Across to specify the Print Direction and move this field to the Displayed Groups list.
Click G_DEPARTMENT_ID, then click Down.
On the Fields page, click the right arrow (>) to move the following fields from the Available Fields list to the Displayed Fields list, then click Next:
On the Labels page, click Next.
On the Template page, make sure Beige is selected under Predefined Template, then click Finish to display your report output in the Paper Design view. It should look like this:
Figure 12-4 Paper Layout view for the across group report