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

Last updated on JULY 21, 2023

Applies to:

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

Purpose

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.

Scope

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.