Defining a Data Set

The report writer defines data sets which are used for providing objects to insert into a report (report definition). A data set contains a SQL query which represents the logic to retrieve data from a single data source. The data set can use parameters in its logic.

When creating a data set, the report writer defines a name for the data set, selects the query type (logical or physical), writes the query, then validates the accuracy of the query before saving it. The intent of the validation is to make sure the query is executed by the system.

Note: When creating data sets, logical SQL is the recommended SQL type over physical SQL.

Note: WHERE("Requisition Identification"."Req. Identifier" = (:req_id)