Syntax of The Scripting LanguageScripting with The Scoop™
The Scoop™ comes with an integrated script language for creating "BeforePrint" and "AfterPrint" event handlers at runtime. While you can allow the end user to do this, the script language is probably more useful for the developer itself. You can use it to design reports with various special features without the need to write source code and to have this hardcoded into your application.
As a simple example, lets say that you have a report printing a list of numbers, some of which may be positive and some may be negative. For this you can write a script for the detail band's "BeforePrint" event at runtime from within the report editor (right-click on the band after you have selected it and choose "Scripts" from the popup menu):
if (Amount>=0)
SetFontColor('AmountDBText',Black)
else
SetFontColor('AmountDBText',Red)
endif
The script language is based on The Scoop’s expression syntax, extended with commands IF, ELSE, ENDIF, LOOP, ENDLOOP, BREAK, EXIT and RETURN, i.e. you can use any expression function in the script (and all script functionality is based on the various functions available). Also you can use variables to store values.
Syntax of The Scripting Language