Report scripts

A report script allows you to customize the processing of the report. A report script consists of event sections in which you program actions to be performed at particular states of execution of the report. The statements programmed in a report script section consist of a combination of 3GL language statements and report script functions.

You program report scripts in the same way as you program 4GL program scripts, except that report scripts use different event sections and some special functions.

Report scripts allow you to:

  • Perform additional queries
  • Calculate complex print expressions
  • Aggregate complex print expressions
  • Update rows in the database
  • Add fields from tables that are not queried by the program script, when you are not able to manipulate the program script
  • Manipulate pre-defined variables in the report, such as if the layout should be printed or not.
Report script structure

A report script consists of one or more event sections in which you program actions to be performed at particular states of execution of the report. The statements programmed in a report script section consist of a combination of 3GL language statements and report script functions.

Report scripts support the following event sections:

  • program sections, e.g. declaration, before.program, and after.program.
  • report sections that correspond to a layout, e.g. before.report, header, and detail. Report sections can be processed before a layout, or after a layout.
  • text field sections

The report script is compiled automatically with the report when you compile the report.

Note

For details on Report scripts, refer to "Report Script Features" in the ERP Enterprise (LN) Programmer's Guide. Predefined variables used in a report are also listed.

To create report scripts

You can create and edit report scripts in the Reports (ttadv3530m000) session.

For more information, refer to the following topics in the Web Help:

  • Reports Overview