<< Click to Display Table of Contents >>   Properties

To create a script in a Report, use the Report's Script Editor, opened by clicking Scripts Editor and to view a Report, click Generate Report. Both options are available on the toolbar of a Report.

Report scripts use some procedures, depending on the object or Section where users want to include code. For example:

Report.Sections("PageHeader").Controls("E3Chart1")._
  GridBkColor= RGB(255, 0, 255)

 

Where:

•PageHeader: This is the name of the Section where this object is inserted in a Report

•E3Chart1: This is the name of the object that is inside the specified Section, in this case PageHeader

•GridBkColor: This is the object's property name, in this case E3Chart1

•RGB (255, 0, 255): This is the property's parameter or action. In this case, changing chart's background color to pink

 

Therefore, to create a script in a Report, use the following concept:

Report.Sections("SectionName").Controls("ObjectName")._
  PropertyName = property_parameters

 

 

The available property on this section is the following:

•Caption