Wednesday, May 4, 2011

About Reports in JD Edwards EnterpriseOne

Sections in a Report
1)   Report Header
2)   Page Header
3)   Detail Sections
a.  Columnar section
b.  Group section
c.  Tabular section
4)   Level break Header section
5)   Level break Footer section
6)   Page Footer section
7)   Report Footer section

Questions
How many numbers detail sections possible in a report template?
Multiple. But the physical page size of report template should not exceed 45 inches in length and width. Report template that exceeds this limit might faces problems at runtime…

How many detail sections can be added in a report template using report director?
Using the Director, only one detail section can be inserted in the report template. Later RDA can be used to enhance the report template and add extra detail sections

How many numbers (max) of Page Header/Page Footer sections possible in a report template?
Only one

How many numbers (max) of Report Header/Report Footer sections possible in a report template?
Only one

Can a business view be attached to a Page header section?
No. Business views can be attached to details sections only

what is the default font used to generate PDF reports in E1?
Arial

Is it possible to print the attachments that are inserted in the report?
No. They are just useful to explain the functionality of the report, any special logic used, documenting the changes etc.,

The properties and format of report headers and footers and of page headers and footers are similar to which detail section?
Group section

Report Templates Vs Batch Versions
Report templates are master specifications of the report. It defines the data used, how the data is
Selected , sorted, displayed, and formatted etc.
Batch versions read the master specifications from the associated report template and over ride one or more specification of the report template like:
• Section layout
• Section data selection
• Section event rules
• Section database output
• Section sort sequence
This concept allows creating requirement specific reports (versions) without touching the Master (i.e Report Template). Basically you create one report template and create multiple version by overriding the specifications.
Report Power points:
·      Report template is a Master specification
·      Batch version is a child i.e business need based customization of the Master

No comments: