Report definition
This model defines the report structure, input parameters and optionally also the data fetch.
Syntax:
Name Component [ LuName ] [ Layer ] [ CodeGenProperties ] Parameters [ Conditions ] [ Texts ] Root Blocks
The structure consists of a root block that aggregates a set of detail data blocks. Each detail can in turn have details of it's own.
First section defines the report name, its component. If not the same as the report name, a logical unit name must also be defined.
report MovieTopList; component APPS8; logicalunit Movie;
An optional section with codegen properties is used when necessary.
codegenproperties { GenerateRdf "yes"; }
This section defines the parameters that are used when ordering the report. These parameters controls the behavior of the order dialog.
parameters { parameter Genre Enumeration<Genre> MW-BL { } parameter Actor Enumeration<Genre> OW-BL { } }
An optional conditions section can be used when a fully generated RDF file is defined. These conditions can then be set on data that only should be fetched when the condition is met.
conditions { condition ActorBiography default FALSE; }
This section contains a list of predefined (and translatable) texts. These texts can later be referred to by name in layout definitions.
texts { text MovieTopList "Top listed movies"; }
The primary root section defines the top level attributes and aggregates.
For fully generated RDF's you can also specify filters, SQL statement, PL/SQL post-processing block and conditional data fetch.
root { filter on Genre; PL/SQL-Block { BEGIN :ActorBiography := (:ActorCount > 0); END; } attributes { attribute ActorCount Number; } aggregates { aggregate ActorData[] Biography() conditionally ActorBiography; } }
This section defines a set of detail blocks that are references as aggregated data from the root block or another detail.
Each detail block specifies its attributes and, in case of deeper structure, also its aggregates.
For fully generated RDF's you can also specify required component, filters, binding attributes, SQL statement, PL/SQL post-processing block and conditional data fetch.
block Biography { bindings { parameter ActorId Number; } SQL-Statement SELECT * FROM actor_personal_data WHERE actor = :ActorId; attributes { attribute SceneIndex Integer; } entities { entity Actor rowkey Rowkey; } } block Scene requires FILMDB { attributes { attribute SceneIndex Integer; attribute Duration Number; attribute Content Text(2000); } entities { } }
This page is generated from IFS Developer Studio at 2021-08-13 08:48.