Welcome Guest Login SignUp








JDE News

Live Radio


JDE Forum Comments/Reviews/Queries
2159 day(s) ago   #154
Name: TechZone
Category: Technical
Location: Singapore
Date: 2014-06-27 20:16:45


FAQ Report Design Aid in JDE E1

How many 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 run-time.

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?

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.

To be continued...

2062 day(s) ago   #162
Name: TechZone
Category: Technical
Location: Singapore
Date: 2014-10-02 20:52:55


FAQ Report Design Aid in JDE E1

Q9 Is it Possible to Force a Page Break on a Report?
A9: Within the Report Writer, standard page breaks occur when data overflows the page causing a page break or based on the Page Break option that can be defined on a Level Break item in the Data Sequencing. However, there are times that a page break needs to occur at some point other then a page overflow or Level Break.

Currently there is not an available system function to cause a page break, but a page break can be forced within a report by using the following workaround. Create a new Group section. This section does not need to be associated with a business view. In the advanced properties of the section, select the options for Page Break After and Conditional. Within the driver section of the report, use event rules to edit for when a page break should occur and at the appropriate time call the new conditional group section using the Do Custom Section system function. This will call the conditional section which does not actually print any information, but does force a page break to occur based on the Page Break After property selected on the section.

Refer to Document 636822.1 for information on page breaks within the Report Design Aid tool.

Q10: What Options that are Available to Columnar and Group Sections are not Available for Tabular Sections?
A10: The following options that are available in columnar and group section reports are not available for tabular reports:

Conditional Section. A tabular section cannot be conditional.
Level Break Headers/Footers. Tabular sections cannot have level break header or footer sections.
Level break information is printed automatically within a tabular section and controlled by the items marked as Level Breaks in the data sequencing.
Parent/Child Subsection Joins are not available in a tabular section.

Q11: How to associate an aggregate variable in a Level Break Footer (LBF) to a variable in a totally independent section than the parent section of the LBF?
A11: No this is not possible.The Aggregate field will always be linked to the corresponding field in the parent section.

Q12: Is it Possible to Define a Default Printer for a Specific Report and Version?
A12: Yes. This is done in the Printers application (P98616). Specify the report and version for the user/role, host and environment and change the status to AV (active).

Q13: How can I define a report to Print Immediate?
A13: There are several available options for defining a report for Print Immediate in EnterpriseOne. Refer to Document 643238.1 E1: PRINT: Available Options for Print Immediate Functionality in EnterpriseOne that defines the various functionality available for setting up a report to Print Immediate.

Q14: Is it possible to override the environment for a report?
A14: Yes. To override the environment for a report, in Report Design Aid, select Report|Report Properties, and then select the Advanced tab. Use the Override Environments feature. This feature will override the environment used by the business view and point to the alternate environment.

This feature applies only to the Business View attached to the report sections. Any Event Rules and Business Function coding that uses Table I/O to fetch information does not read this report property.

Q15: Launching Report Design Aid (RDA.exe) or Table Design Aid (TDA.exe) disables the E1 User account with error: eSecUserDisabled: The user account has been disabled! Please talk to a OneWorld Administrator.
A15: Issue is resolved after removing special character such as % in the EnterpriseOne password.

Thank U!
1842 day(s) ago   #181
Name: TechZone
Category: Technical
Location: Singapore
Date: 2015-05-10 17:17:46


FAQ Report Design Aid in JDE E1

Q16. Explain the report event flow?
  • Initializing section : occurs when a batch process encounters a section for the first time,use this event to do processing immediately before a section begins.this event is useful for working with global variables
  • Advance section : occurs when each time you perform a fetch from the data base use this event if u need processing on objects before the fetch
  • Do section : occurs following an advance section, after values have been assigned to print out to a printer or an output file
  • After last object printed : occurs after a row is printed an output file it is used to process information after a row has been output
  • End section : occurs after a batch process has been completed processing the last set of section values .use this event to do processing immediately after a section ends
Q17.List down some report system function?
Set selection append flag
Set sequence append flag
Set ube error
Set user selection
Stop batch processing
Stop event processing
Use data selection from section
Use data sequence from sequence

Q18.What is the use of text variables in report?
Text variables are used to store strings,which can be attached to the reports,using event rules they are used as alternative to hard coding text strings in assignments

Q19.What is subsection join?
A link established between the two sections in a report by using the common fields,that exist between the different business view.these to sections are called parent and child sections

Q20.What is an aggregate object?
An aggregate object is an object that holds the result of a calculation on the values in other fields.for example the calculation could be a sum of values an average of values or a count of records

Q21.What is smart field?
Smart fields are the fields which provide the ability to add complex and reusable calculations to the report,smart fields are grouped by a field template,which is based on a particular business view it is glossary type is k

Q22.Is it possible to do transaction processing from reports?
Yes, using the transaction processing functions begin,commit and rollback transaction business functions.
1834 day(s) ago   #182
Name: mnr
Category: Technical
Date: 2015-05-18 03:51:06


FAQ Report Design Aid in JDE E1

1825 day(s) ago   #188
Name: Sudarsan
Category: Technical
Date: 2015-05-27 09:39:38


FAQ Report Design Aid in JDE E1

JDE Technical Consulting
Post Comments/Queries
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in