Report
Report Design
Design Tool
Tool
Report Writing
Writing
Report
Report Writing
The
The Section
Section Family
Family Album
Album
These Sections are the ‘building blocks’ of a report:
Report Header Section
Page Header Section
Columnar Section
Group Section
Tabular Section
Page Footer Section
Report Footer Section
Report
Report Header
Header Section
Section
Only one per report
The Report
JDE Industrial Inc.
Fourth Quarter Financial Results
For The Period Ending 12/31/96
Prints once and only
once at the beginning
of the report
Page
Page Header
Header Section
Section
The Report Only one per report
R550945 JDE Industrial Inc. 12/31/96 [Link]
Quarterly Revenues Page: 1
Prints at the beginning
of each page of the
report
Columnar
Columnar Section
Section
Unlimited number
per report
The Report Typically populated
with table data via
a business view
Address Alpha Region Search
Number Name Code Type
1001 Acme Glue Co. DEN C
1556 XYZ Manufacturing NYC C
1785 Dooright, p TOR E
3452 Office Stuff, Inc. CHI V
Cannot change the
columnar format
Group
Group Section
Section
Unlimited number
The Report per report
1001 Acme Glue Co.
DEN C
1556 XYZ Manufacturing
NYC C
Typically populated
1785 Dooright, Dudley with table data via
TOR E a business view
3452 Office Stuff, Inc.
CHI V
Free-form design
capability
Tabular
Tabular Section
Section
Typically populated
The Report with table data via
a business view
Account June Net
Description Posting
Revenue 376,697
Cost of Goods Sold - 272,091 Provides
Gross Profit 104,606 automatic
General Expenses - 63,911 totaling
Net Income 40,695
Offers Drill
Down Feature
Page
Page Footer
Footer Section
Section
Only one per report
The Report
This page reflects Revenue earnings for a single Region
or Branch/Plant.
Prints at the end of
each page of the
report
Report
Report Footer
Footer Section
Section
The Report
Only one per report
All information contained in this report is the legal and
exclusive property of JDE Industrial, Incorporated.
Prints once and only
once at the end of
the report
Exercise
Exercise
Create a new purchase report
Order Company Order Number Order Type Line Number Business Unit
[Link] [Link] [Link] [Link] [Link]
Customer Number Customer Name Order Date 2nd Item Number Unit Cost
F4311.AN8 [Link] [Link] [Link] [Link]
Quantity Ordered Extended Price
[Link] [Link]
Exercise
Exercise
Requirement
Level
Level Breaks
Breaks
Are used to group large amounts of records
into manageable units
Occur when there is a change in report data
Can trigger special processing such as page
breaks, totaling, and headers
R04420 J.D. Edwards & Co. 07/18/96
Page Header Section
[Link]
A/P Open Details Page: 1
ABC Office Supplies - 1244 Group Section - Level
Break Header
Doc Doc Due Amount
Type Number Date
--------- ----------- ------------ -------------- Columnar Section
PV 101 07/31/96 100.00
PV 102 07/31/96 150.00
The Report
--------------- Group Section - Level
Vendor Total 250.00 Break Footer
Bubba’s Cajun Catering - 8856
PV 505 07/31/96 225.00
PV 506 08/15/97 225.00
---------------
Vendor Total 450.00 Group Section - Grand
Total Section
---------------
Grand Total 700.00
Subsection
Subsection Joins
Joins
Each section is
associated with a
Allow you to establish different
a parent/child business view
relationship between
two sections
A link is established
between the sections by a
common field to obtain
information from both
business views
Important
Important Things
Things to
to Remember
Remember
New reports are created by
adding objects and designing
specifications using the
Report Design Tool.
Every report requires at least
one version in order to run.
Versions are based on
report specifications.
Version
Version Overrides
Overrides
R ep o rtin g S tru ctu re
R ep o rt T em p la te
A d d ress B o o k R eco rd s
Override Version
V ersio n 1 Specifications in Version 1
A d d ress B o o k R eco rd s to add a field for Salary.
E m p lo y ees Override Section Layout
Override
Override Section
Section Layout
Layout
R ep o rtin g S tru ctu re
R ep o rt T em p la te Now add a field in
A d d ress B o o k R eco rd s template for Country
V ersio n 1 V ersio n 2 V ersio n 3
A d d ress B o o k R eco rd s A d d ress B o o k R eco rd s A d d ress B o o k R eco rd s
E m p lo y ees C u sto m ers S u p p liers
• Version 1 will not display the new field for Country
because of the Override to Section Layout.
• Versions 2 and 3 will include the new field for Country
as they currently have no overrides to Section Layout.
