My Oracle Support Banner

E1: RDA: Overview of Data Selection and Data Sequence in Report Design Aid (Doc ID 1488722.1)

Last updated on FEBRUARY 23, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
Information in this document applies to any platform.


Data Selection filters the data in order to produce a subset of records that is processed by the report. Define data selection to include only specific, relevant records in the detail section. For example, you can define a report to print a listing of all customers and then define data selection for a batch version to display only customers from New York and data selection on another batch version to display only customers from Paris.

Data Sequence determines the order in which the data is processed and displayed in a report. Data sequencing is the same as data sorting and the terms are interchangeable. For example, define section data sequencing to display records in a detail section by address book number and then by name.

This document gives an overview of Data Selection and Data Sequence in Report Design Aid (RDA). It explains various ways in which Data Selection and Data Sequencing can be applied on reports, what is order of execution of data selection and how security may be applied to restrict selection and sequencing criteria for users. 


This document is intended for the EnterpriseOne developer and covers data selection and sequence on columnar and group section types.

Knowledge of the Report Design Aid Development tool is a prerequisite. The Report Design Aid Guide is available at the EnterpriseOne Documentation site under the appropriate Tools Release level.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Data Selection
 Data Sequence
 Sort Properties
 Defining Data Selection and Data Sequence in Report Design Aid
 Report Template Design
 Multiple Sections in Report Template
 Version Design
 Data Selection and Sequencing and Submitting Batch Versions
 Data Selection Security
 Data Selection Lock Functionality
 Data Selection Security in P00950 - Web client only
 Data Selection Lock and Batch Application Data Selection Security
 Methods of Defining Data Selection
 Section or Version Data Selection
 System Functions within Event Rules
 Row and Column Data Selection
 Order of Execution for each Type of Data Selection
 Additional Information

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.