Generate a data schema from a Genero BDL report program

After you write or modify a Genero report program, you must generate the data schema (rdd) file. This file is used by the Genero Report Designer to provide a list of data objects for use in the report design.

The data schema (rdd) file is based on the SQL statement in your Genero report application source file (4gl). This rdd file is used in the report design document (4rd) to populate the Data View, providing details about the fields that will be streamed by the application. The schema contains the list of database columns that make up your data record, as well as grouping details.

Although the data for the report originally may have come from several different data tables, the PRINT statement in your BDL REPORT program block outputs the data as part of a single record. See the Genero Studio >> Report Writer documentation topic "Writing the BDL Program" for more information.

From the command line

Use the --buildrdd command-line option of the fglcomp tool to create a data schema (rdd file). For example:

fglcomp --build-rdd SimpleReport.4gl

The output of this command will be SimpleReport.rdd. The rdd file will be stored in the same location as the 4gl file.

Note: If your Genero program contains multiple 4gl files, run fglcomp against the file containing your REPORT program block.

From Genero Studio

Add --build-rdd to the Compiler options property for your Genero source (4gl) file to generate the rdd file automatically each time the 4gl file is compiled. Select the 4gl file listing in the application node of the Project tab to display its properties in the Properties View. The rdd file will be stored in the directory specified in the Target Directory property of the application node that contains the 4gl file.