Creating an Example Group Section Report
Use the Director to create this example group section report, which is used for reviewing inventory on hand. A group section format was selected for this report because the information for a specific inventory item is easily reviewed in a group. The data selection filters the data so that inventory items are included in the report for only one business unit, business unit 27. The V41021E - Item Location, Item Master Join business view is attached to the group section, and these business view columns were selected for the section layout:
Location.
Item Number - Short.
Primary Location (P/S).
Category G/L.
Quantity on Hand - Primary Units.
Quantity on Backorder.
Business Unit.
Access RDA.
From the File menu, select New.
On the Create New Report form, enter R5541021 in the Report Name field.
Enter Inventory on Hand in the Description field.
Enter 55 in the Product Code field.
Select the No Update Report option, and click OK.
On the Welcome to the Report Design Director form, select the Page Header and Group sections, and click Next.
On the Page Header Details form, click Next to accept the default.
On the Business View Selection Option form, select the option I'll Find a business view myself, and clickNext.
On the Select Business View form, locate and select the V41021E - Item Location, Item Master Join business view, and click Next.
On the Section Layout form, select these columns in the order listed, and move them to Selected Columns:
Location.
Item Number - Short.
Primary Location (P/S).
Category G/L.
Quantity on Hand - Primary units.
Quantity on Backorder.
Business Unit.
When the selected columns are arranged as indicated, enter 3 in the Number of Columns field, and click Next.
On the Data Sequencing form, move the Location and Item Short columns to Selected Columns, and click Next.
On the Define Sort Properties form, sort the data for both fields in ascending order, and click Next.
On the Data Selection form, complete these fields:
Field
Value
Operator
Where
Left Operand
Business Unit (F41021) (MCU) (BC)
Comparison
is equal to
Right Operand
<Literal>
Select the Single value tab on the Single Value form, enter 27 in the Business Unit field, and click OK.
On the Data Selection form, click Next.
On the Finish form, select Yes, create a version of this report, enter VER0001 as the version name, and click Finish.
On the JD Edwards Report Design Aid form, click Save to save the report.
Select the Preview tab to preview the report.
From the File menu, select Exit to quit RDA.